audit drop procedure; fails with ORA-00956

From: Ethan Post <post.ethan_at_gmail.com>
Date: Fri, 21 Aug 2009 09:19:57 -0500
Message-ID: <357b48a90908210719y68bc37ddxdca61438147fc0c1_at_mail.gmail.com>

SQL> audit create procedure
Audit complete.
SQL> audit create any procedure
Audit complete.
SQL> audit drop any procedure
Audit complete.

• Why does this fail? Isn't this just the opposite of CREATE PROCEDURE. It is listed in the exact same section of the docs as CREATE PROCEDURE, I would think the syntax is the same.

SQL> audit drop procedure
audit drop procedure
Error at line 9
ORA-00956: missing or invalid auditing option

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 21 2009 - 09:19:57 CDT