Updated on 2023-10-23 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 the system administrator or security policy administrator 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

Resource label name. This column 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