Open topic with navigation
DROP ROLE — remove a database role
DROP ROLE [ IF EXISTS ]
role_name[ IF EXISTS ]
DROP ROLE statement to remove a role from the database. When you drop a role, NuoDB revokes it from all users and roles to whom it has been granted and removes it from the database. User sessions in which the role is already enabled are not affected.
If the role does not exist and you specify
IF EXISTS, NuoDB does not generate an error. If not specified and the role does not exist, an error is generated.
The name of the
ROLE to be removed.
DROP ROLE IF EXISTS nosuchrole;