Query DBA_AUDIT_OBJECT for Oracle username of the account used : DBA_AUDIT_OBJECT « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. DBA_AUDIT_OBJECT
SQL> select
  3    Username             /*Oracle username of the account used.*/
 10  from DBA_AUDIT_OBJECT;
SQL>








30.26.DBA_AUDIT_OBJECT
30.26.1.Query DBA_AUDIT_OBJECT for Name of the affected object
30.26.2.Query DBA_AUDIT_OBJECT for Numeric code for the action
30.26.3.Query DBA_AUDIT_OBJECT for Operating system username used
30.26.4.Query DBA_AUDIT_OBJECT for Oracle username of the account used
30.26.5.Query DBA_AUDIT_OBJECT for Owner of the affected object
30.26.6.Query DBA_AUDIT_OBJECT for Terminal ID used