has_schema_privilege()

A system function determining whether a user has a privilege for a schema

has_schema_privilege() is a system function determining whether a user has the specified privilege for the specified schema.

has_schema_privilege() was added in PostgreSQL 7.3.

Usage

has_schema_privilege() has two forms:

The following privileges can be queried:

PostgreSQL 8.4
- able to accept a comma-separated list of privilege types (commit 7449427a)
PostgreSQL 7.3
- added (commit 4ab8e690)

Determine if the current user has the USAGE privilege for the specified schema:

postgres=# SELECT has_schema_privilege('public', 'USAGE');
 has_schema_privilege 
----------------------
 t
(1 row)

Determine if the specified user has the USAGE privilege for the specified schema:

postgres=# SELECT has_schema_privilege('someuser', 'foo', 'USAGE');
 has_schema_privilege
----------------------
 f
(1 row)

Attempting to determine an unrecognized privilege for this object type:

postgres=# SELECT has_schema_privilege('public', 'DELETE');
ERROR:  unrecognized privilege type: "DELETE"

Attempting to determine privileges for a non-existent function:

postgres=# SELECT has_schema_privilege('foo', 'USAGE');
ERROR:  schema "foo" does not exist