Activity overview
Latest activity by JasonKeith
I am a developer who has recently been granted VIEW DEFINITION. This works great. I can now see inside view's and stored procedures. I have used this technique to script using Red Gate SQL Compare. I still have one problem. I can't see permissions for groups I am not a part of. For example in SIT I have access to execute stored procedures. I am a member of an AD_Group called exec_SP. In UAT I do not have this permisssion (I am not in the exec_SP group). When I run Red Gate I see changes for the exec_SP group on all stored procedures. This is because I don't see the group in UAT because I am not part of it.
Are there any permissions that can be added so I can see a true picture of the database without having the power to alter objects? / comments
I am a developer who has recently been granted VIEW DEFINITION. This works great. I can now see inside view's and stored procedures. I have used this technique to script using Red Gate SQL Compare....