diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-09-26 11:50:35 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-09-26 11:50:35 -0400 |
| commit | 1e903c2f00f8b94ae34a8503f63e37b2963eb2cf (patch) | |
| tree | bf2f3bef9a07fd5fe4a4af53547ca823658f4ea2 | |
| parent | 025c9a7226f603823f51a6fde78fc97624269a46 (diff) | |
| download | postgresql-1e903c2f00f8b94ae34a8503f63e37b2963eb2cf.tar.gz postgresql-1e903c2f00f8b94ae34a8503f63e37b2963eb2cf.zip | |
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 1355ecf728d..94f10881b20 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15294,6 +15294,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> @@ -15352,6 +15367,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> @@ -15506,6 +15524,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 |