A Package to Maintain Roles

Normally a procedure executes in the security domain of its owner, but one can 
instruct the procedure to operate in the security domain of the executor.  
However if the procedure quires a table such as user_roles, the results are the 
roles owned by the executor regardless of the security domain, due to the 
predicate on the user_roles table.  

I've been asked if there is anyway to create a view similar to user_roles which 
would return rows as if the owner of the procedure were the package owner, and 
the query was called from a specified package/

I don't like giving out grant option for roles.  Roles lack an owner, but 
looking at who can grant the role gives one a pretty good  idea whom it was 
created by.

Ian MacGregor
Stanford Linear Accelerator Center
ian@xxxxxxxxxxxxxxxxx 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: