Viewing Stored Procedures in SQL server 05

• Ken-306535

  SSC Journeyman

  Points: 86

  More actions

  July 24, 2006 at 7:44 pm

  #366941

  Does anyone know how to make a user for just viewing the stored procedures (user) without the right for modifying it. Is there a special user role for doing this. Since it seems different from SQL 2000 on SQL 05.

  Thanks!!

• BeerBeerBeer

  SSCarpal Tunnel

  Points: 4021

  More actions

  July 24, 2006 at 9:58 pm

  #651242

  Using the Management Studio, drill down to the stored proceudre through database, programmability, stored procedures.

  right click the stoerd procedure and select properties.

  choose the permissions tab

  Last on the list is view definition.

  You could do this in t-sql though

  use database_name

  GO

  GRANT VIEW DEFINITION ON sp_name TO user_name

  GO

  ---

  Regards,

  Steve

  Life without beer is no life at all

  All beer is good, some beers are just better than others