阅读(3460)
赞(14)
PostgreSQL ALTER USER
2021-08-23 14:26:47 更新
ALTER USER — 更改一个数据库角色
大纲
ALTER USER role_specification
[ WITH ] option
[ ... ]
其中 option
可以是:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| REPLICATION | NOREPLICATION
| BYPASSRLS | NOBYPASSRLS
| CONNECTION LIMIT connlimit
| [ ENCRYPTED ] PASSWORD 'password
' | PASSWORD NULL
| VALID UNTIL 'timestamp
'
ALTER USER name
RENAME TO new_name
ALTER USER { role_specification
| ALL } [ IN DATABASE database_name
] SET configuration_parameter
{ TO | = } { value
| DEFAULT }
ALTER USER { role_specification
| ALL } [ IN DATABASE database_name
] SET configuration_parameter
FROM CURRENT
ALTER USER { role_specification
| ALL } [ IN DATABASE database_name
] RESET configuration_parameter
ALTER USER { role_specification
| ALL } [ IN DATABASE database_name
] RESET ALL
其中 role_specification
可以是:
role_name
| CURRENT_USER
| SESSION_USER
描述
ALTER USER
现在是 ALTER ROLE的一种别名。
兼容性
ALTER USER
语句是一种 PostgreSQL扩展。SQL 标准把用户的定义留给 实现来处理。