Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AQ and Privs: Punchy Punchy
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C063B6.97BED4BC
Content-Type: text/plain;
charset="iso-8859-1"
Well, no one ever said that AQ was intuitive. Voila....
Thanks Ross for your comments and your wit !
Lisa
SQL> execute
dbms_aqadm.revoke_system_privilege(privilege=>'MANAGE_ANY',grantee=>'IMED');
PL/SQL procedure successfully completed.
SQL> @SHOWPRIV
"Roles/Privileges for which user or role? - "
( Wildcards OK )
IMED
PRIV GRANTEE TYPE PRIV NAME OWNER TABLE_NAME ---------- ------- ---------------------- ---------- --------------------------- IMED ROLE CONNECT RESOURCE SYSPRIV ADMINISTER RESOURCE MA NAGER CREATE SESSION UNLIMITED TABLESPACE
5 rows selected.
SQL>
------_=_NextPart_001_01C063B6.97BED4BC
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>AQ and Privs: Picky Picky</TITLE>
<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>Well, no one ever said that AQ was intuitive.
Voila....</SPAN></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000></SPAN></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>Thanks Ross for your comments and your wit
!</SPAN></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000></SPAN></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>Lisa</SPAN></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000></SPAN></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>SQL> execute
dbms_aqadm.revoke_system_privilege(privilege=>'MANAGE_ANY',grantee=>'IMED');</SPAN></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>PL/SQL procedure successfully
completed.</SPAN></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>SQL> @SHOWPRIV<BR>"Roles/Privileges for which user
or role? - "<BR>( Wildcards OK )<BR>IMED</SPAN></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>
PRIV<BR>GRANTEE TYPE PRIV
NAME
OWNER TABLE_NAME<BR>---------- -------
---------------------- ---------- ---------------------------<BR>IMED ROLE
![]() |
![]() |