For this topic, assume the following:
The user being migrated (User1) exists on the target server.
The application being migrated (MyApp) contains four databases: MyDb1, MyDb2, MyDb3, and MyDb4.
MyDb1, MyDb2, and MyDb4 exist on the target server.
Before migration, User1 has the following permissions on the source and target servers:
Permissions on Source Server | Permissions on Target Server |
|---|---|
Read for MyDb1 | Read for MyDb1 |
Write for MyDb2 | Calculate for MyDb2 |
Read for MyDb3 | NA |
Write for MyDb4 | Read for MyDb4 |
During migration, User1's permissions on the target server may change, depending upon which of the following migration options is selected:
Do not change permissions of user/group—Permissions do not change. The MyDb3 database is copied to the target, but User1 cannot access it.
Reduce permissions of user/group—Permissions for MyDb1 and MyDb4 do not change. Permissions for MyDb2 are reduced from Calculate to Write. For MyDb3, source-level permissions are granted.
Grant extra permissions to user/group—Permissions for MyDb1 and MyDb2 do not change. For MyDb3, source-level permissions are granted. Permissions for MyDb4 are raised from Read to Write.