audit drop procedure; fails with ORA-00956
- From: Ethan Post <post.ethan@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Aug 2009 09:19:57 -0500
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
Other related posts:
