Grant Usage Privileges on a Schema to the user

    Using below syntax we can grant usage privileges on a schema to required user.

Syntax:
GRANT USAGE ON SCHEMA <Schema Name> TO <User Name>;

Example:
GRANT USAGE ON SCHEMA test_schema TO sample_user;


See also:

• User creation
• Grant usage on schema public
• Create Schema
• Grant all privileges on a schema to the user
• Set default search path