Home » RDBMS Server » Security » Extending SQL Statements (merged) (Oracle)
 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.
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Apr 17 02:26:47 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
