Set default permissions for new stored procedures?

• vnatt

  Valued Member

  Points: 51

  More actions

  May 17, 2018 at 5:20 am

  #330995

  Is there a way to configure it so that any new stored procedures that get created are automatically granted (or inherit) specific permissions?

• Thom A

  SSC Guru

  Points: 99143

  More actions

  May 17, 2018 at 5:22 am

  #1990784

  You could, with a trigger, however, I don't recommend it. Sounds like you need to create a role or set the permissions of the users/roles at a schema level.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  May 17, 2018 at 9:14 am

  #1990863

  You can grant execute on a database or a schema to a user or role. The user or role will inherit execute on all procedures created in that database or schema.

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  May 17, 2018 at 10:19 am

  #1990875

  vnatt - Thursday, May 17, 2018 5:20 AM

  Is there a way to configure it so that any new stored procedures that get created are automatically granted (or inherit) specific permissions?

  Stored procedures are not granted permissions. Users and roles are granted permissions to objects. This might not seem to be helpful, but it's the way to understand how things work and why Thom and Joe's advice work.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2