GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx;
GRANT SELECT ON mytable TO xxx;
GRANT SELECT ON mytable TO xxx;
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