Updated on 2023-10-23 GMT+08:00

GS_AUDITING_POLICY_ACCESS

GS_AUDITING_POLICY_ACCESS records the unified audit information about DML database operations. Only the system administrator or security policy administrator can access this system catalog.

Table 1 GS_AUDITING_POLICY_ACCESS columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

accesstype

name

DML database operation type. For example, SELECT, INSERT, and DELETE.

labelname

name

Resource label name. This column corresponds to the polname column in the GS_AUDITING_POLICY system catalog.

policyoid

oid

OID of the audit policy, corresponding to the OID in the GS_AUDITING_POLICY system catalog

modifydate

timestamp without time zone

Latest creation or modification timestamp