Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> auditing queues

auditing queues

From: oracle_hustler <code_poet_137_at_yahoo.com>
Date: 21 Oct 2005 13:56:15 -0700
Message-ID: <1129928175.758659.86280@z14g2000cwz.googlegroups.com>

  Hello,

    I am currently attempting to audit a "slew" of system privs. The PL/SQL code I wrote was running fine(auditing everything it found in the cursor fetch) until it hit "MANAGE ANY QUEUE". When attempting to audit this priv from the command line I get:

   SQL> AUDIT MANAGE ANY QUEUE;     SQL> ERROR at line 1:

       ORA-00956: missing or invalid auditing option

    My questions are these:

  1. What am I missing if anything
  2. If there is no way to audit these privs then how do I tell PL/SQL to skip over those 3 records when they are found?

    I tried to audit the privs in OEM and found nothing on the web     or in the OEM help files. I thought maybe I could find the SQL statement that way. SO:

    3) Can you audit in OEM? and if so how?

   Thanks for you time and attention Received on Fri Oct 21 2005 - 15:56:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US