RE: AQ and Privs: Picky Picky

From: Bond, Mike <CEMAB_at_cews.okc.disa.mil>
Date: Tue, 30 Jan 2001 07:24:28 -0800
Message-ID: <F001.002A49F3.20010130064720@fatcity.com>

I
tried this and it worked.  There are probably similar procs for the other privs.
<SPAN

class=797494214-30012001> 
<SPAN

class=797494214-30012001>Mike
<SPAN

class=797494214-30012001> 
<SPAN

class=797494214-30012001> 
From
Metalink: <SPAN
class=797494214-30012001>Note:1018015.102
<SPAN

class=797494214-30012001> 
<SPAN

class=797494214-30012001> 
<SPAN

class=797494214-30012001> 
<SPAN

class=797494214-30012001>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);    <FONT face=Tahoma
  size=2>-----Original Message-----From: Koivu, Lisa   [mailto:lkoivu_at_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 <FONT
  face="Courier New" size=1>ENQUEUE ANY QUEUE <FONT   face="Courier New" size=1>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 <FONT face="Courier New"

  size=1>       * <FONT 
  face="Courier New" size=1>ERROR at line 1: <FONT face="Courier New" 
  size=1>ORA-00990: missing or invalid privilege 

  SQL> revoke administer resource manager   from imed; revoke administer
  resource manager from imed <FONT face="Courier New"

  size=1>       * <FONT 
  face="Courier New" size=1>ERROR at line 1: <FONT face="Courier New" 
  size=1>ORA-00990: missing or invalid privilege 

  SQL>
  Lisa Rutland Koivu <FONT
  face=Arial size=1>Oracle Database Administrator <FONT face=Arial   size=1>Qode.com 4850 North State Road   7 Suite G104 <FONT face=Arial
  size=1>Fort Lauderdale, FL  33319
  V: 954.484.3191, x174 <FONT face=Arial   size=1>F: 954.484.2933 C:
  954.658.5849 <A href="http://www.qode.com"   target=_blank>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." Received on Tue Jan 30 2001 - 09:24:28 CST