ON SCHEMA

Syntax

GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }
   ON SCHEMA schema_name [, ...]
   TO role_specification [, ...] [ WITH GRANT OPTION ]

Parameters

ON SCHEMA

Grant privileges on a schema in a database. You can use one statement to grant privileges on several schemas.

CREATE

Privilege to create new tables and views in that schema. To rename an object, you must both own the object and have CREATE privilege for the schema that contains the object.

USAGE

Privilege to access objects in the specified schema (assuming that privileges specific to those objects are met). This privilege allows the role to see objects within the schema, but does not grant SELECT on the tables in the schema. See also Granting Schema-Level Privileges to Members of a Role.

Examples

Grant CREATE and USAGE privileges on schema jbdb to two users:

premdb=# grant all privileges on schema jbdb to yb007,yb008;
GRANT

Grant USAGE privileges on schema jbdb to the role bar:

premdb=# grant usage on schema jbdb to bar;
GRANT

See also Granting Schema-Level Privileges to Members of a Role.