DROP ROLE

Deletes a role.

Synopsis

DROP ROLE role-name

Arguments

role-name

The name of the role to be deleted. The name is an identifier.

Description

The DROP ROLE statement deletes a role. When you drop a role, Caché revokes it from all users and roles to whom it has been granted and removes it from the database.

For DROP ROLE, required permissions are %DROP_ANY_ROLE or WITH ADMIN OPTION privileges. If you invoke DROP ROLE and do not have drop role privileges, SQL issues a –99 Privilege Violation SQLCODE error.

Examples

This example creates a role named BkUser and later deletes it:

  &sql(CREATE ROLE BkName)
  IF SQLCODE=-99 {
  WRITE !,"You don't have CREATE ROLE privileges" }
  ELSE { WRITE !,"Created a role"}
  /* Use role */
  &sql(DROP ROLE BkName)
  IF SQLCODE=-99 {
  WRITE !,"You don't have DROP ROLE privileges" }
  ELSE { WRITE !,"Dropped the role" }