PostgreSql创建数据库,用户以及权限分配
1.创建用户
CREATE USER newuser WITH PASSWORD 'password';
2.创建数据库
CREATE DATABASE newdatabase;
3.给用户赋权
GRANT ALL PRIVILEGES ON DATABASE newdatabase TO newuser;
给用户newuser
数据库(newdatabase
)的所有权限
CREATE USER newuser WITH PASSWORD 'password';
CREATE DATABASE newdatabase;
GRANT ALL PRIVILEGES ON DATABASE newdatabase TO newuser;
给用户newuser
数据库(newdatabase
)的所有权限