Ispirer Website
Ispirer Capabilities: Microsoft SQL Server Migration
Free Trial
Microsoft SQL Server: Setting Up Source User Privileges
As for Microsoft SQL Server, SQLWays utility uses select statements to system tables and views to extract information about the source DDL for all the objects that need to be converted. So, we need to create a login with a default database where objects required for the migration are stored. Create a user for this login and assign the following privileges that are required to support the export for Microsoft SQL Server objects:
- create login sql_test with password = 'Pwd'
- alter login sql_test with default_database = test – Assign the default database 'test' for the login
- use test – We need to create user in the required database, so we need to use it
- create user test_user for login sql_test
Privileges that should be assigned to the user:
- grant select to test_user
- GRANT EXECUTE TO test_user
- GRANT VIEW DEFINITION TO test_user
OR
You can just add your login to a sysadmin role EXEC master..sp_addsrvrolemember @loginame = N'sql_test', @rolename = N'sysadmin'.
If you have any other questions, please contact us: support@ispirer.com