The drop_user operator deletes a user account. Available only in the Enterprise Edition.

SciDB security mode must be correctly configured before this or any security operator can be used. See the /wiki/spaces/SD/pages/242909404 section of the /wiki/spaces/SD/pages/241041535.

Synopsis

drop_user ( 'username' );

Inputs

username - A string literal user name.

Summary

The drop_user operator deletes a user account, preventing further logins by that user.
Requires operator privilege.
As a side effect, deletes the role that was automatically created for this user by create_user.

Example

Betty, a member of the operator role, can delete user Charles.

AFL% show_user();
{i} name
{0} 'betty'
AFL% 
AFL% show_users_in_role('operator');
{No} user
{0} 'betty'
AFL% 
AFL% drop_user('charles');
Query was executed successfully
AFL%

Browser not supported