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!

Unified Auditing for all functions in a schema

Blues BreakerMay 13 2025

Greetings Oracle 19c people,

Hope your day is going well.

I've found a few examples in how to add actions to an existing policy or even creating a new one.

None of them seem to work.

Here is one example that looked very promising but it returned ora-00933 sql command not properly ended.

That's just one that I have tried. I think I tried about 50 others.

ALTER AUDIT POLICY <POLICY_NAME>

ADD ACTIONS EXECUTE ON <SCHEMA_NAME>.<PACKAGE_NAME>.<FUNCTION_NAME>

I tried another example that looked like it would add all functions in the same schema.

That failed as well but that would be my goal.

Any ideas gratefully received. Thanks in advance.

Peace:)

This post has been answered by Gerrit van der Linden on May 14 2025
Jump to Answer
Comments
Post Details
Added on May 13 2025
2 comments
186 views