NAME
DROP USER - 删除一个数据库用户帐号
SYNOPSIS
DROP USER name
DESCRIPTION 描述
DROP USER 从数据库中删除指定的用户。 它不删除数据库里此用户所有的表,视图或其他对象。 如果该用户拥有任何数据库,你会收到一个错误信息。
PARAMETERS 参数
- name
一个现存用户的名称。
NOTES 注意
PostgreSQL 还有一个程序 dropuser [dropuser(1)] , 这个程序和这条命令功能相同(实际上,程序里调用此命令), 但是可以在命令行上运行。
To drop a user who owns a database, first drop the database or change its ownership.
EXAMPLES 例子
删除一个用户帐户:
DROP USER jonathan;
COMPATIBILITY 兼容性
DROP USER 语句是一个 PostgreSQL 的扩展。SQL 标准把用户的定义交给具体实现处理。
SEE ALSO 参见
ALTER USER [alter_user(7)], CREATE USER [create_user(l)]
#p#
NAME
DROP USER - remove a database user account
SYNOPSIS
DROP USER name
DESCRIPTION
DROP USER removes the specified user. It does not remove tables, views, or other objects owned by the user. If the user owns any database, an error is raised.
PARAMETERS
- name
- The name of the user to remove.
NOTES
PostgreSQL includes a program dropuser [dropuser(1)] that has the same functionality as this command (in fact, it calls this command) but can be run from the command shell.
To drop a user who owns a database, first drop the database or change its ownership.
EXAMPLES
To drop a user account:
DROP USER jonathan;
COMPATIBILITY
The DROP USER statement is a PostgreSQL extension. The SQL standard leaves the definition of users to the implementation.
SEE ALSO
ALTER USER [alter_user(7)], CREATE USER [create_user(l)]