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

GS_AUDITING_POLICY_ACCESS

GS_AUDITING_POLICY_ACCESS records the unified audit information about DML database operations. Only a 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 13.2.2 GS_AUDITING_POLICY system catalog.

policyoid

oid

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

modifydate

timestamp without time zone

Latest creation or modification timestamp.