GRANT SELECT ON mytable TO xxx

GRANT SELECT ON mytable TO xxx
ERROR: permission denied for relation xxxx

GRANT SELECT ON ALL TABLES IN SCHEMA public TO yourdbname;

ERROR: permission denied for schema your_schema

See also

• SELECT, GRANT SELECT ON, BETWEEN
• 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