To drop a role, use the following, where role_name is the name of a user-defined role:
drop role role_name [with override]
with override revokes all access privileges granted to the role in every database server-wide.
If the role has any access privileges already granted, you must revoke all privileges granted to the role in all databases before you can drop the role. If you do not, the command fails. To revoke privileges:
Use the revoke command, or
Use the with override option with the drop role command. The with override option ensures that Adaptive Server automatically removes permission information for the role from all databases.
You need not drop memberships before dropping a role. Dropping a role automatically removes any user’s membership in that role, regardless of whether you use the with override option.
