/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

0 vote358 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote333 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote345 views1 answer
Find wordpress version in database
SQL
0 vote338 views1 answer
Import sql dump into postgresql database
SQL
-1 vote336 views2 answers
On update cascade
SQL
0 vote367 views1 answer
List in one column mysql
SQL
0 vote353 views1 answer
Mysql select smaller of two values
SQL
15 votes375 views6 answers
Laravel db transaction
SQL
0 vote331 views1 answer
Mysql date only no time
SQL
0 vote356 views1 answer
Max length found in mysql
SQL