postgres=# CREATE ROLE rolename LOGIN PASSWORD 'password'; CREATE ROLE postgres=# CREATE DATABASE databasename ENCODING 'encoding'; CREATE DATABASE postgres=# GRANT ALL ON DATABASE databasename TO rolename; GRANT
PostgreSQLのロールとデータベースへのアクセス権限
postgres=# CREATE ROLE rolename LOGIN PASSWORD 'password'; CREATE ROLE postgres=# CREATE DATABASE databasename ENCODING 'encoding'; CREATE DATABASE postgres=# GRANT ALL ON DATABASE databasename TO rolename; GRANT