Skip to Main Content

Database Software

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 of Java Class, Resource, and Source

441516Nov 30 2011
We are currently at 10.1.0.5 on Win@K3 server, and are implementing DIACAP requirements. One of the finding states we need to add auditing of objects and they gave us the script to implement this:

AUDIT ALL BY ACCESS;
AUDIT ALL PRIVILEGES BY ACCESS;
AUDIT ALTER JAVA CLASS BY ACCESS;
AUDIT ALTER JAVA RESOURCE BY ACCESS;
AUDIT ALTER JAVA SOURCE BY ACCESS;

When we try to run this in sqlplus, it gives us an error on the Java lines (Ora-00969: Missing ON keyword). According to the documentation I found on line, which was limited, this is the correct syntax. Anyone know why this is failing?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2011
Added on Nov 30 2011
0 comments
228 views