Postgresql 中文操作指南

53.50. pg_shseclabel #

目录 pg_shseclabel 存储着共享数据库对象上的安全标签。可使用 SECURITY LABEL 命令操作安全标签。要更轻松地查看安全标签，请参见 Section 54.22 。

The catalog pg_shseclabel stores 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 Section 54.22.

参见 pg_seclabel ，它对单个数据库内的对象的安全性标签执行类似的功能。

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

与大多数系统目录不同，pg_shseclabel 在集群的所有数据库中共享：每个集群只有一个 pg_shseclabel 的副本，而非每个数据库一个副本。

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 53.50. pg_shseclabel Columns

Column Type

Description

objoid oid (references any OID column)

The OID of the object this security label pertains to

classoid oid (references pg_class.oid)

The OID of the system catalog this object appears in

provider text

The label provider associated with this label.

label text

The security label applied to this object.