SELECT username,owner,obj_name,action_name,timestamp FROM dba_audit_trail WHERE obj_name = 'TABLE_NAME' AND owner = 'SCHEMA_NAME' AND action_name IN ('CREATE', 'ALTER', 'DROP') ORDER BY timestamp DESC FETCH FIRST 1 ROWS ONLY;