PostgreSQL用户权限管理

 

CREATE USER worker PASSWORD '123456' CREATEDB ;  --创建用户时授权可创建数据库
ALTER USER worker CREATEDB; --赋权worker可创建数据库
ALTER USER worker PASSWORD '1234567'; --修改worker用户密码为1234567
CREATE DATABASE testdb OWNER worker; --创建数据库testdb并制定所属用户
GRANT CONNECT ON DATABASE testdb TO worker; --将testdb的连接权限赋予给worker用户
GRANT ALL PRIVILEGES ON DATABASE testdb TO worker; --将testdb的所有权限赋予给worker用户
REVOKE ALL PRIVILEGES ON DATABASE testdb FROM worker;  --将testdb的所有权限从worker用户撤销
ALTER USER worker WITH VALID UNTIL 'infinity'; --设置密码为永不过期
ALTER USER worker WITH VALID UNTIL '2019-05-23 13:00'; --设置密码定时过期
DROP USER worker; --删除用户worker