/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 vote255 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote300 views1 answer
Change role postgres
SQL
0 vote294 views2 answers
Add colum in sql
SQL
0 vote273 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote243 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote269 views1 answer
Install postgresql on raspberry pi
SQL
2 votes291 views2 answers
How to run postgresql in linux
SQL
0 vote261 views1 answer
Concatenate columns in table
SQL
0 vote292 views1 answer
How to join result table in mysql
SQL
0 vote283 views1 answer
View psql output in horizontal scrolling
SQL