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