troubleshooting Question

ALTER AUDIT POLICY CIS_UNIFIED_AUDIT_POLICY ADD ACTIONS CREATE USER; results in ORA-46357: Audit policy CIS_UNIFIED_AUDIT_POLICY not found.

Avatar of talahi
talahi asked on
Oracle Database
2 Comments1 Solution9 ViewsLast Modified:
I received a list of items from a security scan that I need to implement.

Item: Ensure the 'CREATE USER' Action Audit Is Enabled        

Solution: ALTER AUDIT POLICY CIS_UNIFIED_AUDIT_POLICY ADD ACTIONS CREATE USER;    

Result: [Error] Execution (1: 1): ORA-46357: Audit policy CIS_UNIFIED_AUDIT_POLICY not found.

Note Provided: If you do not have CIS_UNIFIED_AUDIT_POLICY, please create one using the CREATE AUDIT POLICY statement.

Question: How to do as the Note suggests?

 There is additional list of items to implement after CREATE USER like,

ALTER AUDIT POLICY CIS_UNIFIED_AUDIT_POLICY ADD ACTIONS DROP USER;      

Note: Using Oracle 19C, non container db.             
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros