To find out Orphaned users
EXEC sp_change_users_login 'Report'
If you already have a login id and password for this user then run below command:
EXEC sp_change_users_login 'Auto_Fix', 'user'
If you want to create a new login id and password for this user, fix it by below command
EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'
EXEC sp_change_users_login 'Report'
If you already have a login id and password for this user then run below command:
EXEC sp_change_users_login 'Auto_Fix', 'user'
If you want to create a new login id and password for this user, fix it by below command
EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'
No comments:
Post a Comment