DROP ROLE

DROP ROLE — remove a database role

Syntax

DROP ROLE [ IF EXISTS ] role_name
DROP ROLE role_name [ IF EXISTS ]

Description

Use the 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.

Parameters

IF EXISTS: 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.
role_name: The name of the ROLE to be removed.

Example

DROP ROLE IF EXISTS account_manager;