GRANT ALL PRIVILEGES ON TABLE your-table TO your-user;
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