Oracle PL/SQL Tutorial/System Tables Data Dictionary/DBA AUDIT SESSION
Содержание
Query DBA_AUDIT_SESSION for Login time
<source lang="sql">
SQL> select
8 TO_CHAR(Timestamp,"DD-MON-YY HH24:MI:SS") /*Login time*/ 10 from DBA_AUDIT_SESSION;
SQL> SQL></source>
Query DBA_AUDIT_SESSION for Logoff time
<source lang="sql">
SQL> select
9 TO_CHAR(Logoff_Time,"DD-MON-YY HH24:MI:SS") /*Logoff time*/ 10 from DBA_AUDIT_SESSION;
SQL> SQL></source>
Query DBA_AUDIT_SESSION for Operating system username used
<source lang="sql">
SQL> select
2 OS_Username /*Operating system username used.*/ 10 from DBA_AUDIT_SESSION;
SQL> SQL></source>
Query DBA_AUDIT_SESSION for Oracle username of the account used
<source lang="sql">
SQL> select
3 Username /*Oracle username of the account used.*/ 10 from DBA_AUDIT_SESSION;
SQL> SQL></source>
Query DBA_AUDIT_SESSION for Terminal ID used
<source lang="sql">
SQL> select
4 Terminal /*Terminal ID used.*/ 10 from DBA_AUDIT_SESSION;
SQL> SQL></source>