Wednesday, September 12, 2018

How to find USER exec DDL on Oracle OBJECT using DBA_AUDIT_TRAIL

set:sqlplus parameter

SET LINESIZE 200
col OBJ_NAME format a20
col OS_USERNAME format a20


set:time format

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';

exec sql:

select
USERNAME, OBJ_NAME, ACTION_NAME, TIMESTAMP,OS_USERNAME,SESSIONID
from
DBA_AUDIT_TRAIL
where
OBJ_NAME like 'OBJECT_NAME'

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout