ORA-00956: Missing or Invalid Auditing Option

(Doc ID 753190.1)

Last updated on JULY 09, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3.0 to 10.2.0.4.0
This problem can occur on any platform.

Symptoms

STMT_AUDIT_OPTION_MAP shows the  following auditing options:

 

NAME 
---------------------------------------- 
...

EXISTS 
GRANT LIBRARY 
CREATE DIRECTORY
DROP DIRECTORY 
...

 


However the audit statements for these are failing :

SQL> audit exits;

ORA-00956: missing or invalid auditing option

SQL> audit grant library;

ORA-00956: missing or invalid auditing option 
                                                                                                             

SQL> audit  create directory;

ORA-00956: missing or invalid auditing option

SQL>  audit drop directoryl;


ORA-00956: missing or invalid auditing option

 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms