drop_user 中文man页面

系统
DROP USER 从数据库中删除指定的用户。 它不删除数据库里此用户所有的表,视图或其他对象。 如果该用户拥有任何数据库,你会收到一个错误信息。

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

责任编辑:韩亚珊 来源: CMPP.net
相关推荐

2011-08-24 14:31:48

DROP LANGUA中文man

2011-08-24 14:35:33

DROP OPERAT中文man

2011-08-24 14:16:18

DROP DATABA中文man

2011-08-24 14:13:27

DROP CONVER中文man

2011-08-24 14:19:14

DROP DOMAIN中文man

2011-08-24 14:06:36

DROP AGGREG中文man

2011-08-24 14:28:47

DROP INDEX中文man

2011-08-24 14:10:10

DROP CAST中文man

2011-08-24 14:25:43

DROP GROUP中文man

2011-08-24 14:40:50

DROP RULE中文man

2011-08-24 14:22:11

DROP FUNCTI中文man

2011-08-24 13:43:09

CREATE USER中文man

2011-08-24 14:57:06

drop_type中文man

2011-08-24 14:49:13

drop_table中文man

2011-08-24 14:43:21

drop_schema中文man

2011-08-24 15:03:08

drop_view中文man

2011-08-24 14:38:16

DROP OPERAT中文man

2011-08-24 14:52:31

drop_trigge中文man

2011-08-24 14:46:42

drop_sequen中文man

2011-08-24 09:51:53

alter_user中文man
点赞
收藏

51CTO技术栈公众号