GRANT ALL

GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
    ON SCHEMA schema_name [, ...]
    TO { username [ WITH GRANT OPTION ] | ROLE role_name | GROUP group_name | PUBLIC } [, ...]

Examples:

GRANT ALL PRIVILEGES ON SCHEMA your_schema TO your_username
GRANT ALL PRIVILEGES ON SCHEMA your_schema TO ROLE your_rolename
GRANT ALL PRIVILEGES ON SCHEMA your_schema TO GROUP your_group

• GRANT ALL PRIVILEGES

• \dn+
• GRANT USAGE

See also

• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE