/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

1 vote238 views1 answer
Sql delete row with auto increment
SQL
0 vote247 views1 answer
Get date ISO in psql
SQL
0 vote276 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote236 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote237 views1 answer
Sql alter table order by
SQL
0 vote251 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote208 views1 answer
Create dabase postgresql
SQL
0 vote242 views1 answer
Mysql update table from select on another table
SQL
0 vote249 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote246 views1 answer
Postrgres trunc
SQL