Home » SQL & PL/SQL » SQL & PL/SQL » Granting privelege only to execute dbms_aqadm.createqueue (Oracle 10g, Windows xp)
Granting privelege only to execute dbms_aqadm.createqueue [message #331457] Thu, 03 July 2008 07:05 Go to next message
Kumarg
Messages: 1
Registered: July 2008
Junior Member
Hi,

Is it possible to give privilege to execute only specific procedures in the package dbms_aqadm? Or is it mandatory to give a complete execute on dbms_aqadm package?
Re: Granting privelege only to execute dbms_aqadm.createqueue [message #331458 is a reply to message #331457] Thu, 03 July 2008 07:07 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, a package is a whole.
If you need this create your own package/procedure upon system one and grant privilege to this new package/procedure.

Regards
Michel
Previous Topic: how to reset all sequences at a time?
Next Topic: Comparing cursor with null
Goto Forum:
  


Current Time: Sat Dec 03 15:57:46 CST 2016

Total time taken to generate the page: 0.07771 seconds