Monday, February 9, 2026

UA_role_hisotry

select dbusername,event_timestamp,action_name,dbms_lob.substr(sql_text, 200) "SQL_TEXT"
from unified_audit_trail
where action_name in ('REVOKE','GRANT') and trunc(event_timestamp) >= to_date('01-JAN-25','DD-MON-YY') and return_code = 0;

No comments:

Post a Comment