How can I tell if I have execute privileges on DBMS_LOCK()?
"I do not fear computers. I fear the lack of them." Isaac Asimov Oracle Scirpts DBA's need
Code: Begin DBMS_Lock.Sleep(10); End; /
Begin DBMS_Lock.Sleep(10); End; /
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
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
Tomaž "A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
That's it! Nice find. Thank you! I thought it only had table privileges (_TAB_). But, we all know what a thought is...
Forum Rules