RE: AQ and Privs: Punchy Punchy

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Mon, 11 Dec 2000 16:09:04 -0500
Message-Id: <10707.124248@fatcity.com>

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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

ROLE   
CONNECT<BR>                   RESOURCE<BR>           SYSPRIV ADMINISTER RESOURCE
MA<BR>                   NAGER<BR>                   CREATE
SESSION<BR>                   UNLIMITED TABLESPACE</SPAN></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>5 rows selected.</SPAN></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=cour size=1><SPAN class=782120721-11122000><SPAN
class=782120721-11122000>SQL> </SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=782120721-11122000><SPAN
class=782120721-11122000></SPAN></SPAN></FONT> </DIV></BODY></HTML> Received on Mon Dec 11 2000 - 15:09:04 CST