Updated on 2025-03-13 GMT+08:00

GS_AUDITING_POLICY_ACCESS

GS_AUDITING_POLICY_ACCESS records the DML database operations about the unified audit. 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

Specifies the resource label name, which corresponds to the polname column in the GS_AUDITING_POLICY system catalog.

policyoid

oid

OID of the audit policy, which corresponds to the OID in the 12.2.1 GS_AUDITING_POLICY system catalog.

modifydate

timestamp without time zone

Latest creation or modification timestamp.