NAME

DROP USER - 刪除一個(gè)數(shù)據(jù)庫用戶帳號(hào)

SYNOPSIS

DROP USER name

DESCRIPTION 描述

DROP USER 從數(shù)據(jù)庫中刪除指定的用戶。 它不刪除數(shù)據(jù)庫里此用戶所有的表，視圖或其他對(duì)象。 如果該用戶擁有任何數(shù)據(jù)庫，你會(huì)收到一個(gè)錯(cuò)誤信息。  

PARAMETERS 參數(shù)

name

 一個(gè)現(xiàn)存用戶的名稱。

NOTES 注意

PostgreSQL 還有一個(gè)程序 dropuser [dropuser(1)] ， 這個(gè)程序和這條命令功能相同（實(shí)際上，程序里調(diào)用此命令）， 但是可以在命令行上運(yùn)行。

To drop a user who owns a database, first drop the database or change its ownership.  

EXAMPLES 例子

 刪除一個(gè)用戶帳戶：

DROP USER jonathan;

COMPATIBILITY 兼容性

DROP USER 語句是一個(gè) PostgreSQL 的擴(kuò)展。SQL 標(biāo)準(zhǔn)把用戶的定義交給具體實(shí)現(xiàn)處理。  

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)]