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