Updated on 2023-10-23 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. This parameter corresponds to the polname column in the system catalog in GS_AUDITING_POLICY.

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.