postgresqlユーザ追加権限追加 - tetsuyaf1100/hello-world GitHub Wiki

データベース mydb に myuser を追加し、閲覧権限を追加する場合

postgres=> CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypassword';
CREATE ROLE
postgres=> GRANT CONNECT ON DATABASE mydb TO myuser;
GRANT

postgres=> \c mydb

mydb=> GRANT USAGE ON SCHEMA PUBLIC TO myuser;
GRANT
mydb=> GRANT SELECT ON ALL SEQUENCES IN SCHEMA PUBLIC TO myuser;
GRANT
mydb=> GRANT SELECT ON ALL TABLES IN SCHEMA PUBLIC TO myuser;
GRANT

参考URL