How To Copy User Roles From One Database To Another

Problem Scenario:

User created new Security System Roles for users of the system and is needed the same roles for their newly created database.

Resolution(s):

User Roles can be copied/imported from an existing database to another/newly created database. Go to Maintenance > User Roles. Select one or all or whichever user roles you need to export to another database.

Right-click > IO > Export > to Xml

Save the file in your preferred folder and this file will be the one to use for importation on the other database.

After saving the file, go to the other database where it will be imported. Right-click > IO > Import > from Xml

Select the file which you have exported from the previous database

You may now link these roles to its corresponding Security System User.

*Export/Import of System Role(s) also includes the System Users assigned to these Roles. Just delete the Users you don’t wish to keep in the other/new database.