diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 78 | ||||
| -rw-r--r-- | doc/src/sgml/ref/security_label.sgml | 3 |
2 files changed, 81 insertions, 0 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index a5ae7c9e91c..5e5f8a75547 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -239,6 +239,11 @@ </row> <row> + <entry><link linkend="catalog-pg-shseclabel"><structname>pg_shseclabel</structname></link></entry> + <entry>security labels on shared database objects</entry> + </row> + + <row> <entry><link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link></entry> <entry>planner statistics</entry> </row> @@ -4681,6 +4686,12 @@ way to view security labels, see <xref linkend="view-pg-seclabels">. </para> + <para> + See also <link linkend="catalog-pg-shseclabel"><structname>pg_shseclabel</structname></link>, + which performs a similar function for security labels of database objects + that are shared across a database cluster. + </para> + <table> <title><structname>pg_seclabel</structname> Columns</title> @@ -4959,6 +4970,73 @@ </sect1> + <sect1 id="catalog-pg-shseclabel"> + <title><structname>pg_shseclabel</structname></title> + + <indexterm zone="catalog-pg-shseclabel"> + <primary>pg_shseclabel</primary> + </indexterm> + + <para> + The catalog <structname>pg_shseclabel</structname> stores security + lables on shared database objects. Security labels can be manipulated + with the <xref linkend="sql-security-label"> command. For an easier + way to view security labels, see <xref linkend="view-pg-seclabels">. + </para> + + <para> + See also <link linkend="catalog-pg-seclabel"><structname>pg_seclabel</structname></link>, + which performs a similar function for security labels involving objects + within a single database. + </para> + + <para> + Unlike most system catalogs, <structname>pg_shseclabel</structname> + is shared across all databases of a cluster: there is only one + copy of <structname>pg_shseclabel</structname> per cluster, not + one per database. + </para> + + <table> + <title><structname>pg_shseclabel</structname> Columns</title> + <tgroup cols="4"> + <thead> + <row> + <entry>Name</entry> + <entry>Type</entry> + <entry>References</entry> + <entry>Description</entry> + </row> + </thead> + <tbody> + <row> + <entry><structfield>objoid</structfield></entry> + <entry><type>oid</type></entry> + <entry>any OID column</entry> + <entry>The OID of the object this security label pertains to</entry> + </row> + <row> + <entry><structfield>classoid</structfield></entry> + <entry><type>oid</type></entry> + <entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry> + <entry>The OID of the system catalog this object appears in</entry> + </row> + <row> + <entry><structfield>provider</structfield></entry> + <entry><type>name</type></entry> + <entry></entry> + <entry>The label provider associated with this label.</entry> + </row> + <row> + <entry><structfield>label</structfield></entry> + <entry><type>text</type></entry> + <entry></entry> + <entry>The security label applied to this object.</entry> + </row> + </tbody> + </tgroup> + </table> + </sect1> <sect1 id="catalog-pg-statistic"> <title><structname>pg_statistic</structname></title> diff --git a/doc/src/sgml/ref/security_label.sgml b/doc/src/sgml/ref/security_label.sgml index 13b62e22aa1..a9eda21b72a 100644 --- a/doc/src/sgml/ref/security_label.sgml +++ b/doc/src/sgml/ref/security_label.sgml @@ -26,13 +26,16 @@ SECURITY LABEL [ FOR <replaceable class="PARAMETER">provider</replaceable> ] ON TABLE <replaceable class="PARAMETER">object_name</replaceable> | COLUMN <replaceable class="PARAMETER">table_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> | AGGREGATE <replaceable class="PARAMETER">agg_name</replaceable> (<replaceable class="PARAMETER">agg_type</replaceable> [, ...] ) | + DATABASE <replaceable class="PARAMETER">object_name</replaceable> | DOMAIN <replaceable class="PARAMETER">object_name</replaceable> | FOREIGN TABLE <replaceable class="PARAMETER">object_name</replaceable> FUNCTION <replaceable class="PARAMETER">function_name</replaceable> ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) | LARGE OBJECT <replaceable class="PARAMETER">large_object_oid</replaceable> | [ PROCEDURAL ] LANGUAGE <replaceable class="PARAMETER">object_name</replaceable> | + ROLE <replaceable class="PARAMETER">object_name</replaceable> | SCHEMA <replaceable class="PARAMETER">object_name</replaceable> | SEQUENCE <replaceable class="PARAMETER">object_name</replaceable> | + TABLESPACE <replaceable class="PARAMETER">object_name</replaceable> | TYPE <replaceable class="PARAMETER">object_name</replaceable> | VIEW <replaceable class="PARAMETER">object_name</replaceable> } IS '<replaceable class="PARAMETER">label</replaceable>' |