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