Grant all Privileges on a Schema to the user

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

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

Example:
GRANT ALL ON SCHEMA test_schema TO sample_user;


See also:

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