Security - Grant access to schema or all stored procs

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  February 28, 2014 at 9:17 am

  #290368

  A short piece on how to grant execute permissions to all stored procedures to a role (no users). It can be with granting to a schema, or perhaps a cursor as well.

• Peter Schott

  SSCrazy Eights

  Points: 9675

  More actions

  February 28, 2014 at 9:26 am

  #1693146

  I think I can handle this one.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  February 28, 2014 at 9:35 am

  #1693152

  Feel free. Shouldn't be too long. Give a procedure and show how it works with a test user or two.

• Peter Schott

  SSCrazy Eights

  Points: 9675

  More actions

  March 4, 2014 at 2:43 pm

  #1694109

  Submitted, but if you think it needs more work or examples, please kick it back to me.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  March 5, 2014 at 2:52 am

  #1694192

  Thanks. I see it, might take a day or two to get to it.