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

GS_AUDITING

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

Table 1 GS_AUDITING columns

Name

Type

Description

polname

name

Policy name, which must be unique.

pol_type

text

Audit policy type. The value can be access or privilege.
  • access: DML operations are audited.
  • privilege: DDL operations are audited.

polenabled

Boolean

Specifies whether to enable a policy.
  • t (true): enabled
  • f (false): disabled

access_type

name

DML database operation type. For example, SELECT, INSERT, and DELETE.

label_name

name

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

priv_object

text

Describes the path of the database asset.

filter_name

text

Logical character string of a filter criterion.