Updated on 2025-07-15 GMT+08:00

GS_AUDITING_POLICY_PRIVILEGES

GS_AUDITING_POLICY_PRIVILEGES records the DDL database operations about the unified audit. Each record corresponds to a design policy. Only users with the SYSADMIN or POLADMIN permission can access this system catalog.

Table 1 GS_AUDITING_POLICY_PRIVI columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

privilegetype

name

DDL database operation type, for example, CREATE, ALTER, and DROP.

labelname

name

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

policyoid

oid

This column corresponds to the OID in the GS_AUDITING_POLICY system catalog.

modifydate

timestamp without time zone

Latest creation or modification timestamp.