We have an issue constantly where developers need to see what code is running on our production servers. They also need to script objects out, query system tables, view what logins are, inspect SQL jobs etc. We also need the ability to look at the server
It seems that the dba's cant figure out how to create a role that can view object level permissions without granting write access.
Is there a way a role can be created that has read-only rights to everything? This would save us a ton of time. Currently we have to email the DBA's to send us scripts for things....big PITA
We would like a solution that will work on all servers without modifying the script to create the role
View Complete Post