ADM_AUDIT_SESSION
ADM_AUDIT_SESSION displays all audit trail records concerning CONNECT and DISCONNECT. The audit information of GaussDB is mainly queried through the gs_query_audit function. This view exists in both PG_CATALOG and SYS schema. Only users with the AUDITADMIN attribute can view audit information.
| Name | Type | Description |
|---|---|---|
| os_username | character varying(255) | Not supported. Its value is NULL. |
| username | character varying(128) | Name of the user whose operation is audited, not the user ID. |
| userhost | character varying(128) | Not supported. Its value is NULL. |
| terminal | character varying(255) | Not supported. Its value is NULL. |
| timestamp | date | Date and time when an audit trail entry is created (user login date and time of the entry created by AUDIT SESSION). |
| action_name | character varying(28) | Action name corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL. NOTE: The action_name column in GaussDB is inconsistent with the audit action of database ORA. |
| logoff_time | date | Not supported. Its value is NULL. |
| logoff_lread | numeric | Not supported. Its value is NULL. |
| logoff_pread | numeric | Not supported. Its value is NULL. |
| logoff_lwrite | numeric | Not supported. Its value is NULL. |
| logoff_dlock | numeric | Not supported. Its value is NULL. |
| sessionid | numeric | Not supported. Its value is NULL. |
| returncode | numeric | Not supported. Its value is NULL. |
| client_id | character varying(128) | Not supported. Its value is NULL. |
| session_cpu | numeric | Not supported. Its value is NULL. |
| extended_timestamp | timestamp(6) with time zone | Timestamp when an audit trail entry is created (user login timestamp of the entry created by AUDIT SESSION in UTC). |
| proxy_sessionid | numeric | Not supported. Its value is NULL. |
| global_uid | character varying(32) | Not supported. Its value is NULL. |
| instance_number | numeric | Not supported. Its value is NULL. |
| os_process | character varying(16) | Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
