Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_slac.stanford.edu