ALTER

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO xxx;

Change password:

ALTER USER YOUR_USER WITH PASSWORD 'your_new_password';

Related

• GRANT SELECT
• Amazon Redshift: grant read only provileges to user
• \ddp *.* lists default access privilege settings
• PostgreSQL meta-commands

See also

• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW
• 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