...Because in Oracle's infinite wisdom <grin>, they poorly named the view "DBA_TAB_PRIVS" when, instead, they should have named the view "DBA_OBJ_PRIVS".
Here is a proof-of-concept of what Dave (Carp) is saying:
Code:
grant execute on xyz to doh;
select privilege, table_name
from dba_tab_privs
where grantee = 'DOH';
PRIVILEGE TABLE_NAME
---------------------------------------- ----------
EXECUTE XYZ
Let us know if you have additional questions.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.