In this blog post, you’ll learn more about the Sybase Error Specified role ‘%1’ is a user extended as role and the reason for receiving this error
Sybase SQL Error Message
Specified role ‘%1’ is a user extended as role
Reason for this Error
Specified role is a user extended as role but FROM USER clause is not specified in DROP ROLE command.