Consider DBMS_RLS for row level security (or as in some other Oracle
marketing-speak has been called the Virtual Private
Database.)
Essentially: you create a package/stored procedure function that returns
a predicate that can be plugged into a WHERE clause; in your case, in your
package instantiation code, you can go off and look at V$SESSION, and then store
some magic value in a package variable; your predicate function will then use
this package variable and return some comparison that would yield TRUE or FALSE
(in the most simple case, you can have it return "1 = 1" or "1 = 0".) Now, use
DBMS_RLS to add a security policy on the table, and give this security policy
the name of your stored procedure/function. Here's how it works: when a user
(any user) performs any DMLs against the table, Oracle looks at the security
policy to find the name of the stored procedure/function; Oracle will then
evaluate the stored procedure/function and apply the value of the stored
procedure/function to the criteria for accessing the table. Voila, you now can
instantly dictate at the table-level what records users will have access
to.
...Rudy
|
Title: Message
- security without using different usernames Ryan
- RE: security without using different usernames Goulet, Dick
- Re: security without using different usernames Tanel Poder
- Re: security without using different usernames Ryan
- Re: security without using different usernames Ryan
- Re: security without using different usernames JApplewhite
- Re: security without using different usernames AK
- RE: security without using different usernames Pardee, Roy E
- Re: security without using different usernames JApplewhite
- Re: security without using different usernames Rudy Zung
- Re: security without using different usernames Ryan
- Re: security without using different usernames Ryan
- Re: security without using different usernames Ryan
- Re: security without using different usernames Mark Richard
- RE: security without using different usernames Mark Brooks
- Re: RE: security without using different usernames rgaffuri
- Re: security without using different usernames Pete Finnigan
- Re: security without using different usernames Don Yu
- Re: security without using different usernames Arup Nanda
- Re: security without using different usernames Don Yu