Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> auditing queues
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:
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
![]() |
![]() |