Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Label Security: Maybe I missed another naming but ...
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...Received on Mon Sep 08 2003 - 06:36:03 CDT
> 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)
>
![]() |
![]() |