Audit alter function syntax
817046Nov 21 2010 — edited Nov 21 2010Hi,
I am using audit alter function, to audit function's etc statement's but getting error on statements; missing the syntax. Refered link "http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4007.htm". did't help to analyze. Below are some of the statements:
SQL> audit alter any function by access;
audit alter function by access
*
ERROR at line 1:
ORA-00969: missing ON keyword
audit alter any materialized view log by access;
audit alter any materialized view log by access
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
audit alter package by access;
audit alter package by access
*
ERROR at line 1:
ORA-00969: missing ON keyword
QL> audit alter public synonym by access
*
ERROR at line 1:
ORA-00956: missing or invalid auditing option
SQL> audit alter role by access;
audit alter role by access
*
ERROR at line 1:
ORA-00956: missing or invalid auditing option
SQL> audit alter synonym by access;
audit alter synonym by access
*
ERROR at line 1:
ORA-00956: missing or invalid auditing option
SQL> audit analyze table by access;
audit analyze table by access
*
ERROR at line 1:
ORA-00956: missing or invalid auditing option
SQL> audit create control file by access;
audit create control file by access
*
ERROR at line 1:
ORA-00969: missing ON keyword
Please help on providing the link/solution where we can get solution's for such above queries.
Regards,
Sridhar.