ADM_AUDIT_SESSION
ADM_AUDIT_SESSION displays all audit trail records concerning CONNECT and DISCONNECT. The audit information of GaussDB is mainly obtained through the pg_query_audit function. This view exists in both PG_CATALOG and SYS schemas. Only users with the AUDITADMIN attribute can view audit information. The action_name column of GaussDB is inconsistent with the audit action of database ORA, and the transactionid column is consistent with the type of transactionid data in database ORA.
| 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(128) | Not supported. Its value is NULL. |
| timestamp | timestamp(0) without time zone | Date and time when an audit trail entry is created (user login date and time of the entry created by the audit session) |
| action_name | character varying(28) | Action name corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL. |
| logoff_time | timestamp(0) without time zone | 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 | character varying(40) | 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 | Time zone of the timestamp when an audit trail entry is created (user login date and time of the entry created by the 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_numeric | 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.
