/SQL/Command to give readonly access to a postgres sql user

Command to give readonly access to a postgres sql user

sudo -u postgres psql
CREATE USER username WITH PASSWORD 'your_password';
GRANT CONNECT ON DATABASE database_name TO username;
GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;
ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name
GRANT SELECT ON TABLES TO username;

Source: tableplus.com

Similar codes

9 votes189 views1 answer
Sql server get utc date
SQL
0 vote180 views1 answer
Get only first row mysql
SQL
0 vote228 views1 answer
Sql grant select only
SQL
-1 vote192 views1 answer
How to check table exists or not in postgresql
SQL
5 votes230 views1 answer
Get column name sql server
SQL
4 votes184 views1 answer
Id primary key auto generated
SQL
1 vote204 views2 answers
Snowflake alter column data type
SQL
0 vote277 views1 answer
Alter database name script
SQL
0 vote147 views1 answer
Oracle list all stored procedures
SQL
0 vote243 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL