Read only permissions to all procedures & functions

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  February 28, 2012 at 2:57 am

  #269217

  Hi,

  Please provide solution to give read only permission to all Stored procedures & Functions for A perticular user (Ex : BOB) in SQl server 2005

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  February 28, 2012 at 4:07 am

  #1452482

  If it is your intention to just let him see the definition of procedures en functions you could GRANT SELECT permissions on sys.sql_modules or maybe even better create a view based on it and GRANT permissions on your view.

  [font="Verdana"]Markus Bohse[/font]

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 28, 2012 at 4:28 am

  #1452491

  GRANT VIEW DEFINITION TO BOB

  -- Gianluca Sartori

• sumitagarwal781

  Default port

  Points: 1493

  More actions

  February 28, 2012 at 5:04 am

  #1452514

  Check this article.

  http://www.mssqltips.com/sqlservertip/1593/granting-view-definition-permission-to-a-user-or-role-in-sql-server/

  java