Skip navigation

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.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.