/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 vote187 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote177 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote234 views1 answer
SQL get max per id
SQL
-1 vote193 views1 answer
Sql select data from one database and insert into a different database
SQL
4 votes199 views2 answers
Bulk kill mysql processlist
SQL
3 votes210 views2 answers
MySQL query to get column names
SQL
0 vote187 views1 answer
Update one column from another column in same table
SQL
0 vote176 views3 answers
Postgresql grant alter table to user
SQL
0 vote171 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
3 votes218 views5 answers
Duplicate table sql
SQL