Wednesday, March 7, 2012

Permission to see stored procs but not change or exec them?

In Server 2000, our developers can see our stored procs but not change them or run them. In 2005, our developers can not see them at all but claim they need to. I am new to 2005 and have not found a way to achieve this. I would like to grant them access to see the procs and read the code but not change it or execute it. Do you know how this can be done?

Thanks!

hi,

Grant "view definition" permission to user.

regards

sufian

No comments:

Post a Comment