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

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.