From CEMAB@cews.okc.disa.mil Tue, 30 Jan 2001 07:24:28 -0800 From: "Bond, Mike" Date: Tue, 30 Jan 2001 07:24:28 -0800 Subject: RE: AQ and Privs: Picky Picky Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: AQ and Privs: Picky Picky I tried this and it worked.  There are probably similar procs for the other privs.   Mike     From Metalink: Note:1018015.102       Solution Description:=====================This privilege has to be granted manually till OEM Release 2.1.To grant ADMINISTER RESOURCE MANAGER system privilege to a user manually, the package "DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE" has to be used.Example:   To grant ADMINISTER RESOURCE MANAGER privilege to scott user with admin  option:  SQL> CONNECT system/manager  SQL> EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE                ('SCOTT','ADMINISTER_RESOURCE_MANAGER', TRUE);  -----Original Message-----From: Koivu, Lisa [mailto:lkoivu@qode.com]Sent: Monday, December 11, 2000 2:22 PMTo: Multiple recipients of list ORACLE-LSubject: AQ and Privs: Picky Picky Hello everyone, As a routine exercise during install of a third-party product, I checked privileges and (suprise) the schema owner has every single darn privilege granted to it.  I asked the vendor for a specific list of necessary privileges in order for the app to execute and got the standard "I don't know, let me ask support" and no answer.  So being the picky person I am, I revoked all privs and granted connect & resource.  However there are a few system privs that I just can't revoke: ADMINISTER RESOURCE MANAGER DEQUEUE ANY QUEUE ENQUEUE ANY QUEUE MANAGE ANY QUEUE When I try to revoke them I get the errors below.  I looked around in the documentation and it doesn't say anything about granting and revoking these privileges directly - all the AQ privs are part of a role and I found nothing specific about "resource manager". Any suggestions are appreciated.  Thanks SQL> revoke dequeue any queue from imed; revoke dequeue any queue from imed        * ERROR at line 1: ORA-00990: missing or invalid privilege SQL> revoke administer resource manager from imed; revoke administer resource manager from imed        * ERROR at line 1: ORA-00990: missing or invalid privilege SQL> Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL  33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."