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