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 schemas. By default, only the system administrator can access this view. Common users can access the view only after being authorized.
| 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 | 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_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 ORA. |
| 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 trail 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_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 ORA. |
| scn | numeric | Not supported. Its value is NULL. |
| sql_bind | nvarchar2(2000) | Not supported. Its value is NULL. |
| sql_text | character varying | 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
