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

Query DBA_AUDIT_OBJECT for Name of the affected object

   <source lang="sql">

SQL> select

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

SQL>

 </source>
   
  

Query DBA_AUDIT_OBJECT for Numeric code for the action

   <source lang="sql">

SQL> select

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

SQL>

 </source>
   
  

Query DBA_AUDIT_OBJECT for Operating system username used

   <source lang="sql">

SQL> select

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

SQL>

 </source>
   
  

Query DBA_AUDIT_OBJECT for Oracle username of the account used

   <source lang="sql">

SQL> select

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

SQL>

 </source>
   
  

Query DBA_AUDIT_OBJECT for Owner of the affected object

   <source lang="sql">

SQL> select

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

SQL>

 </source>
   
  

Query DBA_AUDIT_OBJECT for Terminal ID used

   <source lang="sql">

SQL> select

 4    Terminal             /*Terminal ID used.*/
10  from DBA_AUDIT_OBJECT;

SQL>

 </source>