Options

Permissions are not being scripted

arosemaarosema Posts: 2 Bronze 1
edited September 9, 2010 10:51AM in SQL Compare Previous Versions
I have developers that are a part of the db_owner role in development and are db_datareader members in production. I have granted them view definition at the schema level to allow them to see the code to compare to, but this does not allow them to see the permissions on the tables, stored procedures and such. Do you know of a way for me to grant them this permission without giving them the right to add/change/delete at the same time?

I did make sure that they were a member of the public role and I also added them as db_datareader to master, but that did not resolve the issue.
Sign In or Register to comment.