ADM_AUDIT_TRAIL
ADM_AUDIT_TRAIL displays all standard audit trail entries. The audit information of GaussDB is mainly queried through the pg_query_audit function. This view exists in both PG_CATALOG and SYS schemas. Only users with the AUDITADMIN attribute and the SELECT permission on ADM_AUDIT_TRAIL can view audit information. If separation of duties is disabled, users with the SYSADMIN attribute can also view audit information.
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 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. Its value is NULL. |
action_name |
character varying(28) |
Action type corresponding to the code in the action column.
NOTE:
The action_name column in GaussDB is inconsistent with the audit action of database A. |
new_owner |
character varying(128) |
Not supported. Its value is NULL. |
new_name |
character varying(128) |
Not supported. Its value is NULL. |
obj_privilege |
character varying(32) |
Not supported. Its value is NULL. |
sys_privilege |
character varying(40) |
Not supported. Its value is NULL. |
admin_option |
character varying(1) |
Not supported. Its value is NULL. |
grantee |
character varying(128) |
Not supported. Its value is NULL. |
audit_option |
character varying(40) |
Not supported. Its value is NULL. |
ses_actions |
character varying(19) |
Not supported. Its value is NULL. |
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. |
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 |
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. Its value is NULL. |
global_uid |
character varying(32) |
Not supported. Its value is NULL. |
instance_number |
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.
NOTE:
The type of the transactionid column in GaussDB must be the same as that in database A. |
scn |
numeric |
Not supported. Its value is NULL. |
sql_bind |
nvarchar2(2000) |
Not supported. Its value is NULL. |
sql_text |
nvarchar2 |
SQL text of the query.
NOTE:
The sql_text column in GaussDB is the parsed SQL description statement, which is not completely the same as the executed SQL statement. |
obj_edition_name |
character varying(128) |
Not supported. Its value is NULL. |
dbid |
numeric |
Not supported. Its value is NULL. |
rls_info |
clob |
Not supported. Its value is NULL. |
current_user |
character varying(128) |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot