This system table contains all sessions if auditing is enabled. This system table can be cleared by the statement TRUNCATE AUDIT LOGS. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
Column Name | Description |
---|---|
SESSION_ID | ID of the session |
LOGIN_TIME | Login time |
LOGOUT_TIME | Logout time |
USER_NAME | User name |
CLIENT | Client application used by the user |
DRIVER | Used driver |
ENCRYPTED | Flag whether the connection is encrypted |
HOST | Computer name or IP address from where the user has logged-in |
OS_USER | User name used by the user to log into the operating system of the computer from where the login came |
OS_NAME | Operating system of the client server |
SUCCESS |
|
ERROR_CODE | Error code if the login failed |
ERROR_TEXT | Error text if the login failed |