Updated on 2024-05-07 GMT+08:00

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.