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
