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

Revisions

  1. thanglequoc created this gist Sep 12, 2019.
    6 changes: 6 additions & 0 deletions MapLoginToDBUser.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    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