How can I tell if I have execute privileges on DBMS_LOCK()?
Printable View
How can I tell if I have execute privileges on DBMS_LOCK()?
Code:Begin
DBMS_Lock.Sleep(10);
End;
/
Nice. But...
What's the system table with that information?
How can I get a list of who has been granted execute priv's on DBMS_LOCK() without connecting as each user then testing for an error?
all_tab_privs
That's it! Nice find. Thank you!
I thought it only had table privileges (_TAB_). But, we all know what a thought is...