RE: AQ and Privs: Picky Picky

[Bond, Mike]

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:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 2:22 PM
To: Multiple recipients of list ORACLE-L
Subject: 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."