Oracle PL/SQL/System Tables Views/DBA AUDIT OBJECT

Query DBA_AUDIT_OBJECT for Name of the affected object

 
SQL> select
  6    Obj_Name             /*Name of the affected object.*/
 10  from DBA_AUDIT_OBJECT;
SQL>

Query DBA_AUDIT_OBJECT for Numeric code for the action

 
SQL> select
  7    Action_Name,          /*Numeric code for the action.*/
 10  from DBA_AUDIT_OBJECT;
SQL>

Query DBA_AUDIT_OBJECT for Operating system username used

 
SQL> select
  2    OS_Username,          /*Operating system username used.*/
 10  from DBA_AUDIT_OBJECT;
SQL>

Query DBA_AUDIT_OBJECT for Oracle username of the account used

 
SQL> select
  3    Username             /*Oracle username of the account used.*/
 10  from DBA_AUDIT_OBJECT;
SQL>

Query DBA_AUDIT_OBJECT for Owner of the affected object

 
SQL> select
  5    Owner                /*Owner of the affected object.*/
 10  from DBA_AUDIT_OBJECT;
SQL>

Query DBA_AUDIT_OBJECT for Terminal ID used

 
SQL> select
  4    Terminal             /*Terminal ID used.*/
 10  from DBA_AUDIT_OBJECT;
SQL>