Hello
I want to audit whenever any user creates/alters/drops any table in the database. I created the policy below but it does not seem to audit anything, i.e. I can create/alter/drop a table and nothing is audited:
CREATE AUDIT policy table_pol actions DROP TABLE, CREATE TABLE, ALTER TABLE container = ALL;
AUDIT policy table_pol;
Is this possible to be achieved? I can see the policy in audit_unified_enabled_policies when I am connected to the PDB. Am I missing something? I am using 19c in a PDB database in OCI and we just upgraded the DB to unified auditing so probably!
Thanks
Luis