Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ GS_AUDITING_PRIVILEGE
Updated on 2025-08-19 GMT+08:00
View PDF

GS_AUDITING_PRIVILEGE

GS_AUDITING_PRIVILEGE displays all audit information about database DDL-related operations. Only the users with SYSADMIN or POLADMIN permission can access this view.

Table 1 GS_AUDITING_PRIVILEGE columns

Name

Type

Description

polname

name

Policy name, which must be unique.

pol_type

text

Audit policy type. The value 'privilege' indicates that DDL operations are audited.

polenabled

Boolean

Specifies whether to enable the policy.

  • t (true): enabled.
  • f (false): disabled.

access_type

name

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

label_name

name

Resource label name. This column corresponds to the polname column in the GS_AUDITING_POLICY system catalog.

priv_object

text

Full domain name of a database object.

filter_name

text

Logical character string of a filter criterion.
Parent topic: System Views