Restrict EXEC permisisons on a stored proc

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  June 19, 2008 at 3:20 pm

  #381219

  I have a stored proc that I only want one user (and the dbo) to be able to EXECute. This doesn't work:

  use [AdventureWorks]

  DENY EXECUTE ON [dbo].[uspLogError] to public

  GRANT EXECUTE ON [dbo].[uspLogError] TO [Tom]

  What is the correct sql?

  TIA,

  barkingdog

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 19, 2008 at 3:38 pm

  #831441

  Put it in its own schema, Deny acces to the Schema, then grant access to the object.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]