diff options
| author | Bruce Momjian <bruce@momjian.us> | 2004-07-12 20:23:59 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2004-07-12 20:23:59 +0000 |
| commit | e47cbb3bad32cfb5fca5e6c70798534c9c51fc2b (patch) | |
| tree | 8ec50c7e8423c565602eedb1eb0daad5e4c839b2 /doc/src | |
| parent | 1a0f3e476b1861e2fa04dfd88f4f2ff823a1ee0f (diff) | |
| download | postgresql-e47cbb3bad32cfb5fca5e6c70798534c9c51fc2b.tar.gz postgresql-e47cbb3bad32cfb5fca5e6c70798534c9c51fc2b.zip | |
Add has_tablespace_privilege().
Christopher Kings-Lynne
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index cb7a5a00d98..998f693c79b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.213 2004/07/02 22:49:45 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.214 2004/07/12 20:23:47 momjian Exp $ PostgreSQL documentation --> @@ -6980,6 +6980,21 @@ SELECT set_config('log_statement_stats', 'off', false); <entry><type>boolean</type></entry> <entry>does current user have privilege for schema</entry> </row> + <row> + <entry><literal><function>has_tablespace_privilege</function>(<parameter>user</parameter>, + <parameter>tablespace</parameter>, + <parameter>privilege</parameter>)</literal> + </entry> + <entry><type>boolean</type></entry> + <entry>does user have privilege for tablespace</entry> + </row> + <row> + <entry><literal><function>has_tablespace_privilege</function>(<parameter>tablespace</parameter>, + <parameter>privilege</parameter>)</literal> + </entry> + <entry><type>boolean</type></entry> + <entry>does current user have privilege for tablespace</entry> + </row> </tbody> </tgroup> </table> @@ -6999,6 +7014,9 @@ SELECT set_config('log_statement_stats', 'off', false); <indexterm zone="functions-misc"> <primary>has_schema_privilege</primary> </indexterm> + <indexterm zone="functions-misc"> + <primary>has_tablespace_privilege</primary> + </indexterm> <para> <function>has_table_privilege</function> checks whether a user @@ -7064,6 +7082,14 @@ SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute'); <literal>USAGE</literal>. </para> + <para> + <function>has_tablespace_privilege</function> checks whether a user + can access a tablespace in a particular way. The possibilities for its + arguments are analogous to <function>has_table_privilege</function>. + The desired access privilege type must evaluate to + <literal>CREATE</literal>. + </para> + <para> To evaluate whether a user holds a grant option on the privilege, append <literal> WITH GRANT OPTION</literal> to the privilege key |