Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Secuity Question
"Barmanjon" <barmanjon2002_at_yahoo.co.uk> wrote in message
news:fff1d6ac.0212290754.3e9816da_at_posting.google.com...
> Hey all...
>
> I am after some help..
>
> I have a database where i want only employees within a particular
> organisation to read details about other employees. So basically
> people within one organisation cant read details about other users in
> another organisation within the company.
>
> I just need some help on how i would go about setting up this sort of
> thing...
>
> I dont want to clog up the newsgroup by asking question after question
> so if anyone can help me drop me a line at barmanjon2002_at_yahoo.co.uk..
>
> Thanks,
>
> Jon
You need to look up Virtual Private Databases (or the older terms for this
feature - Fine-Grained Access Control or Row-Level Security) at
http://tahiti.oracle.com. Basically, you create a login trigger that sets
the context for that user. You then apply security policies to the tables to
which you want to restrict access. VPD automatically adds a predicate to the
WHERE clause (eg, "and emp_id = whatever").
Received on Sun Dec 29 2002 - 10:50:33 CST