ADM_AUDIT_OBJECT

ADM_AUDIT_OBJECT displays the audit trail records of all objects in the database. This view exists in both PG_CATALOG and SYS schema. By default, only the system administrator can access this view. Common users can access the view only after being authorized. The action_name column of GaussDB is different from that of the ORA database in terms of the audit actions. The type of the transactionid column is the same as that in the ORA database. In GaussDB, the sql_text column is the parsed SQL statement, which is not completely the same as the executed SQL statement.

**Table 1** ADM_AUDIT_OBJECT 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(255)	Not supported. Its value is NULL.
timestamp	timestamp(0) without time zone	Date and time when an audit trace 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_name	character varying(28)	Action name corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
new_owner	character varying(128)	Not supported. Its value is NULL.
new_name	character varying(128)	Not supported. Its value is NULL.
ses_actions	character varying(19)	Not supported. Its value is NULL.
comment_text	character varying(4000)	Not supported. Its value is NULL.
sessionid	numeric	Not supported. Its value is NULL.
entryid	numeric	Not supported. Its value is NULL.
statementid	numeric	Not supported. Its value is NULL.
returncode	numeric	Not supported. Its value is NULL.
priv_used	character varying(40)	Not supported. Its value is NULL.
client_id	character varying(128)	Not supported. Its value is NULL.
econtext_id	character varying(64)	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 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.
transactionid	text	Identifier of the transaction that accesses or modifies an object
scn	numeric	Not supported. Its value is NULL.
sql_bind	Ncharacter varying(2000)	Not supported. Its value is NULL.
sql_text	Ncharacter varying(2000)	SQL text of the query.
obj_edition_name	character varying(128)	Not supported. Its value is NULL.