Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PG_SHSECLABEL
Updated on 2024-09-02 GMT+08:00
View PDF
Share

PG_SHSECLABEL

PG_SHSECLABEL records security labels on shared database objects. Security labels can be manipulated with the SECURITY LABEL command.

For an easier way to view security labels, see PG_SECLABELS.

See also PG_SECLABEL, which performs a similar function for security labels involving objects within a single database.

Unlike most system catalogs, PG_SHSECLABEL is shared across all databases of a cluster. There is only one copy of PG_SHSECLABEL per cluster, not one per database.

Table 1 PG_SHSECLABEL columns

Name

Type

Reference

Description

objoid

oid

Any OID column

OID of the object this security label pertains to

classoid

oid

PG_CLASS.oid

OID of the system catalog where the object resides

provider

text

N/A

Label provider associated with this label

label

text

N/A

Security label applied to this object
Parent topic: System Catalogs