Create Unified Audit policy in Oracle for specific user

 create audit policy table_pol PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE WHEN 'SYS_CONTEXT(''USERENV'',''SESSION_USER'')=''SCOTT''' evaluate per session;

Enable the audit policy

audit policy table_pol;

Check the audit policy table:

set linesize 300
column dbusername format a30

select dbusername, action_name from unified_audit_trail;