| Extending SQL Statements (merged) [message #426744] |
Mon, 19 October 2009 05:12  |
kipoyph
Messages: 1
Registered: October 2009
|
Junior Member |
|
|
Hi,
I'm new to Oracle. I came upon what has been told to me as an Oracle feature and I would like to know how it is implemented.
It seems that if one user sends an SQL statement to the database, it is possible for Oracle to append an extension of the where clause.
For example, if I send a
"select from table 1 where col1 = 'a'",
Oracle can extend my where clause. If the user is of ROLE1, the server can extend my SQL statement to
"select from table 1 where col1 = 'a' and col2 = 'b'"
or, if the user is ROLE2, the server can extend my SQL stament to
"select from table 1 where col1 = 'a' and col3 = 'c'".
I tried searching for tips on these but I couldn't find any, so far. Can anybody please explain how this works? It seems to have something
to do with the DBA_POLICIES table and defining some SYS_CONTEXT values.
Any help will be appreciated.
|
|
|
|
| Re: Extending SQL Statements (merged) [message #426746 is a reply to message #426744] |
Mon, 19 October 2009 05:18  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Search for Virtual Private Database (VPD) or DBMS_RLS (Row Level Security) on your version documentation.
When you post ALWAYs specify your Oracle version (at least 2 decimals).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
