Granting Permission

[TekLight]

Hi,
I want to grant permissin to a Database developer to view the stored procedures in Sql server 2000/2005 ,He can also read the data .I can grant him datareader permission but then he can't access the procs.If I make him Db_owner it will be too much for him.

can some one help me with this.What db role i should grant him to view the procs and read the data (No modifications to any)

 

[VDavid]

Hi,
I don't know if there is a role for stored procedures, what I do is give the person execute permission one procedure at a time.

grant execute on PROCEDURE_NAME to USER_NAME

I think there is a way to create a role with the permissions you need, but I haven't done it.

Hope hits helps.
David