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 | 1d473b567e43a84c60428a9f70602acd4deac530 (patch) | |
| tree | e3bc87f81a19bfc2933ba627070ed9e24c1fa51f | |
| parent | fc37e2afa04c612c35e33e0ce447be296ba6bb02 (diff) | |
| download | postgresql-1d473b567e43a84c60428a9f70602acd4deac530.tar.gz postgresql-1d473b567e43a84c60428a9f70602acd4deac530.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 dabcd3e7de0..960342973ce 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -15835,6 +15835,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> @@ -15893,6 +15908,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> @@ -16047,6 +16065,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 |