ON SCHEMA

Syntax

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

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.

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

Parent topic:GRANT