Tag Archives: User Access

TSQL to find users and their access on a given database

TSQL to find users and their access on a given database

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

How to give access to Users in Secondary Always-On/Mirror Server

When we need to provide access to users on a secondary database we will be able to create a login but not user on the read-only database. To address the problem we need to create the Login with same SID … Continue reading

Posted in High Availability, SQL, SQL Query, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

User Access Automation during database restoration

I would like to share user access automation scripts during Database restoration I have performed earlier this year. This script is most customized for user access management when database is restored from production to Dev/UAT environment. We restore multiple databases … Continue reading

Posted in Script, SQL | Tagged , , , | 1 Comment