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 Security section of the SciDB Administration Guide.

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.

To avoid accidentally recreating a user when restoring a backup, you should suspend the user rather than dropping them. See User Accounts.

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%