Updated on 2023-10-23 GMT+08:00

GS_POLICY_LABEL

GS_POLICY_LABEL records the resource label configuration information. One resource label corresponds to one or more records, and each record identifies the resource label to which a database resource belongs. Only the system administrator or security policy administrator can access this system catalog.

Fully Qualified Domain Name (FQDN) identifies an absolute path of a database resource.

Table 1 GS_POLICY_LABEL columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

labelname

name

Resource label name

labeltype

name

Resource tag type. Currently, the value is RESOURCE.

fqdnnamespace

oid

OID of a namespace to which an identified database resource belongs

fqdnid

oid

OID of an identified database resource. If the database resource is a column, this column is the OID of the catalog.

relcolumn

name

Column name. If the identified database resource is a column, this column indicates the column name. Otherwise, this column is empty.

fqdntype

name

Type of the identified database resource, for example, schema, table, column, or view