In this blog post, you’ll learn more about the Sybase Error The role ‘%1’ was not dropped because it is granted to other users or roles. Use the ‘WITH REVOKE’ option to drop it. and the reason for receiving this error
Sybase SQL Error Message
The role ‘%1’ was not dropped because it is granted to other users or roles. Use the ‘WITH REVOKE’ option to drop it.
Reason for this Error
The role being dropped has been granted to other users or roles with WITH NO ADMIN OPTION or with WITH ADMIN OPTION. A role can be dropped when either all of its grants are with WITH ADMIN ONLY OPTION or WITH REVOKE option is specified in DROP ROLE command. Either revoke all such grants or use WITH REVOKE option for DROP ROLE.
