|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.270 2005/07/25 22:12:30 tgl Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.271 2005/07/26 00:04:17 tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -8427,6 +8427,21 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, .. |
8427 | 8427 | <entry><type>boolean</type></entry> |
8428 | 8428 | <entry>does current user have privilege for language</entry> |
8429 | 8429 | </row> |
| 8430 | + <row> |
| 8431 | + <entry><literal><function>pg_has_role</function>(<parameter>user</parameter>, |
| 8432 | + <parameter>role</parameter>, |
| 8433 | + <parameter>privilege</parameter>)</literal> |
| 8434 | + </entry> |
| 8435 | + <entry><type>boolean</type></entry> |
| 8436 | + <entry>does user have privilege for role</entry> |
| 8437 | + </row> |
| 8438 | + <row> |
| 8439 | + <entry><literal><function>pg_has_role</function>(<parameter>role</parameter>, |
| 8440 | + <parameter>privilege</parameter>)</literal> |
| 8441 | + </entry> |
| 8442 | + <entry><type>boolean</type></entry> |
| 8443 | + <entry>does current user have privilege for role</entry> |
| 8444 | + </row> |
8430 | 8445 | <row> |
8431 | 8446 | <entry><literal><function>has_schema_privilege</function>(<parameter>user</parameter>, |
8432 | 8447 | <parameter>schema</parameter>, |
@@ -8473,6 +8488,9 @@ SET search_path TO <replaceable>schema</> <optional>, <replaceable>schema</>, .. |
8473 | 8488 | <indexterm zone="functions-info"> |
8474 | 8489 | <primary>has_language_privilege</primary> |
8475 | 8490 | </indexterm> |
| 8491 | + <indexterm zone="functions-info"> |
| 8492 | + <primary>pg_has_role</primary> |
| 8493 | + </indexterm> |
8476 | 8494 | <indexterm zone="functions-info"> |
8477 | 8495 | <primary>has_schema_privilege</primary> |
8478 | 8496 | </indexterm> |
@@ -8536,6 +8554,14 @@ SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute'); |
8536 | 8554 | <literal>USAGE</literal>. |
8537 | 8555 | </para> |
8538 | 8556 |
|
| 8557 | + <para> |
| 8558 | + <function>pg_has_role</function> checks whether a user |
| 8559 | + can access a role in a particular way. The possibilities for its |
| 8560 | + arguments are analogous to <function>has_table_privilege</function>. |
| 8561 | + The desired access privilege type must evaluate to |
| 8562 | + <literal>MEMBER</literal>. |
| 8563 | + </para> |
| 8564 | + |
8539 | 8565 | <para> |
8540 | 8566 | <function>has_schema_privilege</function> checks whether a user |
8541 | 8567 | can access a schema in a particular way. The possibilities for its |
|