|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.194 2004/03/10 20:10:26neilc Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.195 2004/03/19 19:13:26tgl Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -6881,15 +6881,19 @@ SELECT has_table_privilege('myschema.mytable', 'select'); |
6881 | 6881 | arguments are analogous to <function>has_table_privilege</function>. |
6882 | 6882 | When specifying a function by a text string rather than by OID, |
6883 | 6883 | the allowed input is the same as for the <type>regprocedure</> data type. |
6884 | | - The desired access privilege type mustcurrentlyevaluate to |
| 6884 | + The desired access privilege type must evaluate to |
6885 | 6885 | <literal>EXECUTE</literal>. |
| 6886 | + An example is: |
| 6887 | +<programlisting> |
| 6888 | +SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute'); |
| 6889 | +</programlisting> |
6886 | 6890 | </para> |
6887 | 6891 |
|
6888 | 6892 | <para> |
6889 | 6893 | <function>has_language_privilege</function> checks whether a user |
6890 | 6894 | can access a procedural language in a particular way. The possibilities |
6891 | 6895 | for its arguments are analogous to <function>has_table_privilege</function>. |
6892 | | - The desired access privilege type mustcurrentlyevaluate to |
| 6896 | + The desired access privilege type must evaluate to |
6893 | 6897 | <literal>USAGE</literal>. |
6894 | 6898 | </para> |
6895 | 6899 |
|
|