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

Example

DROP ROLE IF EXISTS nosuchrole;