Sybase Error – Use of WITH NO SYSTEM PRIVILEGE INHERITANCE option is not allowed with %1

In this blog post, you’ll learn more about the Sybase Error Use of WITH NO SYSTEM PRIVILEGE INHERITANCE option is not allowed with %1 and the reason for receiving this error

Sybase SQL Error Message

Use of WITH NO SYSTEM PRIVILEGE INHERITANCE option is not allowed with %1

Reason for this Error

WITH NO SYSTEM PRIVILEGE INHERITANCE option can be specified only with user defined roles corresponding to legacy non-inheritable authorities.