Home » RDBMS Server » Security » Extending SQL Statements (merged) (Oracle)
Extending SQL Statements (merged) [message #426744] Mon, 19 October 2009 05:12 Go to next message
Messages: 1
Registered: October 2009
Junior Member

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 Go to previous message
Michel Cadot
Messages: 68259
Registered: March 2007
Location: Nanterre, France, http://...
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).

Previous Topic: privileges to access another objects
Next Topic: privilege for Alter fixed_date parameter
Goto Forum:

Current Time: Tue Aug 16 02:03:04 CDT 2022