Skip to content

Instantly share code, notes, and snippets.

@ThangLeQuoc

ThangLeQuoc/MapLoginToDBUser.sql

Created September 12, 2019 07:14
Show Gist options
  • Save ThangLeQuoc/8c41219a8952cea9fa35c55828dd2c99 to your computer and use it in GitHub Desktop.
Save ThangLeQuoc/8c41219a8952cea9fa35c55828dd2c99 to your computer and use it in GitHub Desktop.
Download ZIP
Map MSSQL Login Credentials To An Existing Database User
Raw
MapLoginToDBUser.sql
USE [nacwgrAuthor_UAT_Replica_thangle]
ALTER USER nacwgr_author WITH LOGIN = nacwgr_author
USE [nacwgrCluster_UAT_Replica_thangle]
ALTER USER nacwgr_cluster WITH LOGIN = nacwgr_cluster
USE [nacwgrPublic_UAT_Replica_thangle]
ALTER USER nacwgr_public WITH LOGIN = nacwgr_public
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment