MY_AUDIT_TRAIL

MY_AUDIT_TRAIL displays the standard audit trail entries related to the current user. The GaussDB audit information is mainly obtained through the pg_query_audit() function. This view exists in both the PG_CATALOG and SYS schemas. Only users with the AUDITADMIN attribute and the SELECT permission on MY_AUDIT_TRAIL can view audit information. If separation-of-duty is disabled, users with the SYSADMIN attribute can also view audit information. The action_name field of GaussDB is different from that of the ORA database in terms of the audit actions. The type of the transactionid field is the same as that in the ORA database. In GaussDB, the sql_text field is the parsed SQL statement, which is not completely the same as the executed SQL statement.

In a distributed system, the pg_query_audit() function can only be used to query the audit information of the current node.

**Table 1** MY_AUDIT_TRAIL columns
Name	Type	Description
os_username	character varying(255)	Not supported. Set it to NULL.
username	character varying(128)	Name of the user whose operation is audited, not the user ID.
userhost	character varying(128)	Not supported. Set it to NULL.
terminal	character varying(255)	Not supported. Set it to NULL.
timestamp	date	Date and time when an audit trail entry is created in the local database session time zone (user login date and time of the entry created by the audit session).
owner	character varying(128)	Creator of the object affected by the operation.
obj_name	character varying(128)	Name of the object affected by the operation.
action	numeric	Not supported. Set it to NULL.
action_name	character varying(28)	Action type corresponding to the code in the action column.
new_owner	character varying(128)	Not supported. Set it to NULL.
new_name	character varying(128)	Not supported. Set it to NULL.
obj_privilege	character varying(32)	Not supported. Set it to NULL.
sys_privilege	character varying(40)	Not supported. Set it to NULL.
admin_option	character varying(1)	Not supported. Set it to NULL.
grantee	character varying(128)	Not supported. Set it to NULL.
audit_option	character varying(40)	Not supported. Set it to NULL.
ses_actions	character varying(19)	Not supported. Set it to NULL.
logoff_time	date	Not supported. Set it to NULL.
logoff_lread	numeric	Not supported. Set it to NULL.
logoff_pread	numeric	Not supported. Set it to NULL.
logoff_lwrite	numeric	Not supported. Set it to NULL.
logoff_dlock	character varying(40)	Not supported. Set it to NULL.
comment_text	character varying(4000)	Not supported. Set it to NULL.
sessionid	numeric	Not supported. Set it to NULL.
entryid	numeric	Not supported. Set it to NULL.
statementid	numeric	Not supported. Set it to NULL.
returncode	numeric	Not supported. Set it to NULL.
priv_used	character varying(40)	Not supported. Set it to NULL.
client_id	character varying(128)	Not supported. Set it to NULL.
econtext_id	character varying(64)	Not supported. Set it to NULL.
session_cpu	numeric	Not supported. Set it to 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. Set it to NULL.
global_uid	character varying(32)	Not supported. Set it to NULL.
instance_number	numeric	Not supported. Set it to NULL.
os_process	character varying(16)	Not supported. Set it to NULL.
transactionid	text	Identifier of the transaction that accesses or modifies an object.
scn	numeric	Not supported. Set it to NULL.
sql_bind	nvarchar2(2000)	Not supported. Set it to NULL.
sql_text	nvarchar2	SQL text of the query.
obj_edition_name	character varying(128)	Not supported. Set it to NULL.
dbid	numeric	Not supported. Set it to NULL.
rls_info	clob	Not supported. Set it to NULL.
current_user	character varying(128)	Not supported. Set it to NULL.