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

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%