Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Audit alter function syntax

817046Nov 21 2010 — edited Nov 21 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2010
Added on Nov 21 2010
2 comments
1,391 views