Updated on 2024-06-03 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 parameter corresponds to the polname column in the 12.2.9.1 GS_AUDITING_POLICY system catalog.

policyoid

oid

This parameter corresponds to OIDs in the 12.2.9.1 GS_AUDITING_POLICY system catalog.

modifydate

timestamp without time zone

Latest creation or modification timestamp.