command to give readonly access to a postgres sql user

Solutions on MaxInterview for command to give readonly access to a postgres sql user by the best coders in the world

Search
showing results for - "command to give readonly access to a postgres sql user"
Tommaso
15 Apr 2020
1sudo -u postgres psql
2CREATE USER username WITH PASSWORD 'your_password';
3GRANT CONNECT ON DATABASE database_name TO username;
4GRANT USAGE ON SCHEMA schema_name TO username;
5GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;
6ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name
7GRANT SELECT ON TABLES TO username;
8
source
similar questions
postgresql grant owner to useraccess the postgres psqlpsql show with user is logged ingrant read only privileges postgres userhow to give access to database in postgresql server to another usergrant all privileges database postgres to userpostgres login and connect as default userpostgresql grant all privileges on databasepostgresql change user role grantlist all permissions on a table in postgrespostgresql check privileges on schemaset username and password for postgresql databasepostgresql user permissions to databasepsql set access privilegeshow do i add a user to a postgres database 3f cligrant schema permissions postgresuseradd postgresuser privileges postgresql information schema
queries leading to this page
command to give readonly access to a postgres sql usercommand to give readonly access to a postgres sql user