Skip to main content

DROP ROLE (bSQL) | Blockpoint Docs

Drops a user role from the database. For examples, see Examples.

bSQL Syntax Conventions

Syntax

DROP ROLE { role_name }

Arguments

role_name
Specifies the name of the role to be dropped.

Remarks

Roles that have members cannot be dropped from the database. To drop a role that has members, you must first remove members of the role.

Permissions

Requires AUTH permission on the database, or membership of admin fixed database role.

Examples

The following example drops the database role purchasing from the database.

DROP ROLE purchasing

See Also