Madeira TeamMar 3, 20161 minHow to Grant Permissions Only on the Replica in Database Mirroring and AlwaysOn AGYou work with Database Mirroring or AlwaysOn AG, and you want to make sure your end users work only on the secondary server. How should...
Madeira TeamFeb 16, 20155 minThe Risk of Ownership ChainingRecently, I encountered at work the true meaning of ownership chaining and a security risk it can cause. I was asked to define a login...
Madeira TeamMay 23, 20111 minCopy LoginSometimes you need to create a new login from an existing login. For example, recently I helped one of my customers to move all the...
Madeira TeamMar 4, 20101 minCreate Executer RoleDatabase fixed roles are predefined roles with specific permissions that allow their members to take actual roles in the organization....