UA_user_history

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