Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Label Security: Maybe I missed another naming but ...

Re: Label Security: Maybe I missed another naming but ...

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 08 Sep 2003 08:15:06 -0700
Message-ID: <1063034085.725585@yasure>


Jonathan Lewis wrote:

>There was an article with enough code to set
>up a first working example in a very recent
>Oracle Magazine - it is on line, but I don't
>recall the URL. When I read it it looked
>complete.
>
>One little detail you might want to watch
>out for when experimenting. If you add
>Label Security to a database, it does
>create a few extra database-level triggers,
>which fire on things like create/drop table.
>You might want to build a separate database
>for testing it on.
>
>--
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
>One-day tutorials:
>http://www.jlcomp.demon.co.uk/tutorial.html
>
>____Finland__September 22nd - 24th
>____Norway___September 25th - 26th
>____UK_______December (UKOUG conference)
>
>Three-day seminar:
>see http://www.jlcomp.demon.co.uk/seminar.html
>____USA__October
>____UK___November
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
>news:1062992833.725047_at_yasure...
>
>
>>I'm fine with ROW LEVEL SECURITY and it equates to DBMS_RLS
>>I am fine with creating CONTEXTS
>>I am fine with VIRTUAL PRIVATE DATABASE
>>
>>But I have been all over tahiti.oracle.com trying to figure out how
>>LABEL SECURITY works, how it is different, trying to find a demo.
>>
>>And everything I find refers to stuff that isn't in my database,
>>
>>
>like
>
>
>>SA_COMPONENTS, and it isn't defined in anything in RDBMS_ADMIN. In
>>
>>
>fact
>
>
>>it is some of the worst documentation I've ever seen from the
>>
>>
>standpoint
>
>
>>of getting started.
>>
>>So far I've looked at (9.2.0.4 on W2K, Solaris 2,8, and HP/UX 11,
>>
>>
>and
>
>
>>9.2.0.3 on AIX 5L).
>>
>>Thanks.
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>
>>
>>

Thanks. Well at least we've established that OLS is not RLS. If you can find the URL I'd greatly appreciate it.

Thanks again.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Sep 08 2003 - 10:15:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US