删除用户

删除用户 “删除数据库用户

句法

DROP 用R name [ IF EXISTS ]

描述

Use the 删除用户 statement to remove a user from the database.

If you use 删除用户 to drop a user created with 创建用户 username EXTERNAL, the user will be dropped as an active NuoDB database user, but this will have no effect on the user’s在外部LDAP服务器中的条目。

参数

IF EXISTS

If the user does not exist and you specify IF EXISTS, NuoDB does not generate an error. Otherwise, if the user does not exist, an error is generated.

name

用户名称

例子

CREATE 用R jonathan PASSWORD 'jonathan';
DROP 用R jonathan;

DROP 用R nosuchuser IF EXISTS;
DROP 用R nosuchuser;
can't find user "NOSUCHUSER"