One Exception

I mention in the main article that the only kinds of permissions that are inheritable are those that you can grant, such as SELECT, INSERT, UPDATE, and DELETE. However, one exception to this rule is the RAISERROR command, which lets a user or application generate its own error message. Any user can run RAISERROR, but a user who isn't in the sysadmin role can specify only an error level less than 19. However, if a sysadmin user creates a procedure in which RAISERROR is called with a severity greater than 18, any user who has permissions can successfully run that procedure.