Granting permissions to stored procs

• zaizaisql

  SSC Journeyman

  Points: 85

  More actions

  February 27, 2011 at 8:02 pm

  #231743

  hi,

  if I grant execute to a stored proc, does it also grant access to the objects called in the stored procedure? like to tables, views, functions, etc

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  February 27, 2011 at 9:35 pm

  #1292144

  If 'EXEC' is the only permission you configured for user then answer is NO.

  ----------
  Ashish

• zaizaisql

  SSC Journeyman

  Points: 85

  More actions

  February 27, 2011 at 9:43 pm

  #1292146

  thank you

• philwren999

  Grasshopper

  Points: 19

  More actions

  February 28, 2011 at 1:49 am

  #1292186

  If you did want the user to be able to do this without giving the user rights to the table you can use the EXECUTE AS clause in the stored procedure:

  http://msdn.microsoft.com/en-us/library/ms188354(v=SQL.90).aspx