Amazon Redshift: GRANT

• https://docs.aws.amazon.com/redshift/latest/dg/r_GRANT.html

GRANT USAGE ON { DATABASE shared_database_name [, ...] | SCHEMA shared_schema}
    TO { username | GROUP group_name | PUBLIC } [, ...]

GRANT ALL PRIVILEGES 

Schema level permissions

• USAGE: Allows users to access objects in the schema. User still needs specific table-level permissions for each table within the schema
• CREATE: Allows users to create objects within a schema using CREATE statement

• Amazon Redshift: show permissions

See also

• Amazon Redshift, aws redshift, Amazon Redshift query editor, GRANT, AQUA, has schema privilege, WLM, Amazon Redshift Spectrum, metrics, VACUUM, SET