/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

5 votes195 views4 answers
Upload database mysql command line
SQL
0 vote189 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote183 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote183 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote182 views1 answer
Restore backupfile discourse
SQL
0 vote204 views1 answer
Returning with sqlalchemy
SQL
-1 vote206 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote231 views2 answers
How to type a blank discord messgae
SQL
1 vote197 views1 answer
Median mysql
SQL
0 vote225 views1 answer
Create a plsql object
SQL