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






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








30.27.DBA_AUDIT_SESSION
30.27.1.Query DBA_AUDIT_SESSION for Login time
30.27.2.Query DBA_AUDIT_SESSION for Logoff time
30.27.3.Query DBA_AUDIT_SESSION for Operating system username used
30.27.4.Query DBA_AUDIT_SESSION for Oracle username of the account used
30.27.5.Query DBA_AUDIT_SESSION for Terminal ID used