Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

Deletes a role. Note that role cannot be dropped if there are permissions granted to the role, in this case error message will be displayed and you need manually to drop permissions granted to the role and retry. For more information, see Role-based access control.
A role cannot be dropped if there are permissions granted to the role. In this case, an error message will be displayed, and you need to manually drop the permissions granted to the role and retry.

​
Syntax

DROP ROLE [ IF EXISTS ] <role_name>

​
Parameters

ParameterDescription
<role_name>The name of the role.

​
Example

The following command will delete the role “user_role” 
DROP ROLE user_role;

​
Example 2

The following command will delete the role “my_role_2” 
DROP ROLE IF EXISTS my_role_2
If “my_role_2” does not exist, no error message is thrown.