diff options
| author | Tom Lane | 2016-09-26 15:50:35 +0000 |
|---|---|---|
| committer | Tom Lane | 2016-09-26 15:50:35 +0000 |
| commit | a4afb2b5c0b409bb175c20104b2ae9d47cf71be6 (patch) | |
| tree | 8b66ed98a501fa34c5e184d4afab00efebb6123c | |
| parent | 12788ae49e1933f463bc59a6efe46c4a01701b76 (diff) | |
Document has_type_privilege().
Evidently an oversight in commit 729205571. Back-patch to 9.2 where
privileges for types were introduced.
Report: <20160922173517.8214.88959@wrigleys.postgresql.org>
| -rw-r--r-- | doc/src/sgml/func.sgml | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 3cc69bbffd3..67de029c6aa 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15898,6 +15898,21 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, .. <entry>does current user have privilege for tablespace</entry> </row> <row> + <entry><literal><function>has_type_privilege</function>(<parameter>user</parameter>, + <parameter>type</parameter>, + <parameter>privilege</parameter>)</literal> + </entry> + <entry><type>boolean</type></entry> + <entry>does user have privilege for type</entry> + </row> + <row> + <entry><literal><function>has_type_privilege</function>(<parameter>type</parameter>, + <parameter>privilege</parameter>)</literal> + </entry> + <entry><type>boolean</type></entry> + <entry>does current user have privilege for type</entry> + </row> + <row> <entry><literal><function>pg_has_role</function>(<parameter>user</parameter>, <parameter>role</parameter>, <parameter>privilege</parameter>)</literal> @@ -15956,6 +15971,9 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, .. <primary>has_tablespace_privilege</primary> </indexterm> <indexterm> + <primary>has_type_privilege</primary> + </indexterm> + <indexterm> <primary>pg_has_role</primary> </indexterm> <indexterm> @@ -16110,6 +16128,18 @@ SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute'); </para> <para> + <function>has_type_privilege</function> checks whether a user + can access a type in a particular way. + Its argument possibilities + are analogous to <function>has_table_privilege</function>. + When specifying a type by a text string rather than by OID, + the allowed input is the same as for the <type>regtype</> data type + (see <xref linkend="datatype-oid">). + The desired access privilege type must evaluate to + <literal>USAGE</literal>. + </para> + + <para> <function>pg_has_role</function> checks whether a user can access a role in a particular way. Its argument possibilities |