Updated on 2024-06-03 GMT+08:00

GS_AUDITING_ACCESS

GS_AUDITING_ACCESS displays all audit information about database DML-related operations. Only the users with system administrator or security policy administrator permission can access this view.

Table 1 GS_AUDITING_ACCESS columns

Name

Type

Description

polname

name

Policy name, which must be unique.

pol_type

text

Audit policy type. The value is 'access', indicating that DML operations are audited.

polenabled

Boolean

Specifies whether the policy is enabled.

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

access_type

name

DML database operation type. 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.

access_object

text

Path of the database asset.

filter_name

text

Logical character string of a filter criterion.