Return
-
Title
MNE SQL Permissions -
Description
Which MNE SQL permissions you need for the migration ?
-
Resolution
RESOLUTION:
- MNE SQL System Roles:
bulkadmin: This is used for performing BULK INSERT operations, such as when exportingthe Notes Directory, importing TSV files, etc.dbcreator: This is only required when creating the database.You don't 'need' to remove it, but you can if you want to.sysadmin: This is not required but you can use it if you want to.- MNE SQL Database Roles:
db_owner: This role is required when performing an upgradeif the upgrade contains a schema change.It is also required for bulk insert operations.NMEAdmin: This role gives you read/write access to all databasetables, and execute permissions on all stored procedures.NMEReadOnly: This role gives you read access to all database tables.It allows you to log into the console and view configuration & statusreports, but does not allow you to perform any migration tasks.For normal migration operations, you need either the db_owner or NMEAdmin role.- The NMEAdmin role does not grant enough rights to perform
BULK INSERT operations, so some features won't workthat you might not expect, such as editing the members of a user collection.- We would recommend granting db_owner rights to ensure that all features work as expected.
The account that is used to create the database is automatically granteddb_owner rights, so if you are using that account, no additional databasesecurity level permission changes are necessary.- To be clear:
The migration account needs BOTH the bulkadmin role AND the db_owner rolefor all features to work as expected.