Unified Auditing Policies - Schema Browser

Logged into a 19.25 PDB as SYS.

In the Schema Browser, Unified Audit Policies, is there any way to view the SUCCESS and FAILURE values from the AUDIT_UNIFIED_ENABLED_POLICIES view? From the SQL Tracker, it doesn't look like these columns are being retrieved.

--------------------------------------------------------------------------------
Timestamp: 5/12/2025 18:02:07

select *
from SYS.AUDIT_UNIFIED_POLICIES
where (NOT (AUDIT_OPTION_TYPE = 'DV ACTION' and OBJECT_NAME is null))
order by policy_name, audit_option_type, audit_option

--------------------------------------------------------------------------------
Timestamp: 5/12/2025 18:02:10

select POLICY_NAME, ENTITY_NAME
from SYS.AUDIT_UNIFIED_ENABLED_POLICIES
--------------------------------------------------------------------------------

If not, please consider this as a feature request.

Doug

Has anyone on the team had a chance to review this yet?

Hi Doug,

I think you're right. I don't see way to get that info either. I've logged this to add to Toad 25.3.

-John

Hi John, Is this feature on the horizon for a future 25R3 beta drop?

Doug

Hi Doug,

Nope. It's in the rear-view mirror. Pavel added this early in an early beta.

We wanted to add something to the RHS that list that shows when multiple (or zero) UAPs are selected in the left, but that only makes sense for the ones that are enabled for all users, because UAPs with conditional enablement as shown above can have multiple values.

Awesome, looks good to me.

1 Like