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 pg_query_audit function. This view exists in both PG_CATALOG and SYS schema. Only users with the AUDITADMIN attribute can view audit information.

**Table 1** ADM_AUDIT_SESSION columns
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 trace 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 A.
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	Timestamp when an audit trace 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_numeric	numeric	Not supported. Its value is NULL.
os_process	character varying(16)	Not supported. Its value is NULL.