Ing database usernames to login names

Copy the database file on the database server to another machine. After attaching the file, the original database user cannot be mapped to the login name when the new login name is created. In this way, you must use the schema name. Object Name to access the database with the newly created login name.

You can solve this problem by using the following methods:

Step 1:

Exec sp_change_users_login 'report'

List isolated users of the current database

Step 2:

Exec sp_change_users_login 'Auto _ fix', 'username'

You can automatically add the login with the same name as the user name to syslogins.

Step 3:

Exec sp_change_users_login 'Update _ one', 'username', 'username'

Maps the user name to the specified Login Name.

 

Copy the database file on the database server to another machine. After attaching the file, the original database user cannot be mapped to the login name when the new login name is created. In this way, you must use the schema name. Object Name to access the database with the newly created login name.

You can solve this problem by using the following methods:

Step 1:

Exec sp_change_users_login 'report'

List isolated users of the current database

Step 2:

Exec sp_change_users_login 'Auto _ fix', 'username'

You can automatically add the login with the same name as the user name to syslogins.

Step 3:

Exec sp_change_users_login 'Update _ one', 'username', 'username'

Maps the user name to the specified Login Name.