Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/fix_ophran_users.sql

Created June 10, 2023 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save radityopw/f6ab0a7370e4ba925e9452f7adc55046 to your computer and use it in GitHub Desktop.
Save radityopw/f6ab0a7370e4ba925e9452f7adc55046 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fix_ophran_users.sql
-- pilih database dan cek apakah ada perbedaan user dengan login
USE [nama database];
EXEC sp_change_users_login 'Report';
-- jika user dan login memiliki nama yang sama, gunakan autofix
EXEC sp_change_users_login 'Auto_Fix', '<nama user>';
-- jika user dan login memiliki nama yang berbeda, lakukan penyematan ulang
ALTER USER <nama user> WITH LOGIN = <nama login>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment