DROP ORGANIZATION ROLE

Deletes an organization role.

By default, 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.

You can also use the CASCADE option to delete the role and all the grants that depend on it.

​

Syntax

DROP ORGANIZATION ROLE [ IF EXISTS ] <role_name> [ CASCADE | RESTRICT ]

​

Parameters

​

Example

The following command will delete the role account_manager:

DROP ORGANIZATION ROLE account_manager;

The following command will delete the role account_manager_2:

DROP ORGANIZATION ROLE IF EXISTS account_manager_2

In the previous code example, if account_manager_2 does not exist, no error message is returned.

The following command will delete the role account_manager_3 and all the grants that depend on it:

DROP ORGANIZATION ROLE account_manager_3 CASCADE