602SQL Documentation Index  

Export and Import of All Users

It's usually required that the server still works with the same users and user groups after new database installation, as it was in the previous installation, and that it's not necessary to manually create all users, user groups their privileges again. The simplest way of achieving this is to export users from the old database and then import them to the new database.

If the data and object privileges in an application are to be kept intact, it's required to export the whole application from the old database including privileges (a flag when exporting an application).

Commands for user export and import are available in the System / Tools folder.

Export users - exports user and user groups information (including the "who belongs where" relations) to a file on a drive. It's used for transferring the interface to a new database file.

Import users - imports information from the previous paragraph. Used mainly when creating a new database if you want to keep the interface of the original database. Following import of applications exported including all privileges allows you to start working with the new database immediately.

Warning: User passwords are bound to the server identification. Therefore a question whether the passwords are to be deleted is asked when importing users. If the passwords are deleted, each user will be assigned an empty password and will be required to specify a new password on first login to the database.

Configuration administrator, who is importing users can use one of these methods:

  1. Either he sets all passwords to be deleted and forces users to specify new passwords. Setting the new passwords has to be done before application import, otherwise a risk of exploiting somebody other's access privileges may occur.
  2. Or immediately after creating the database file the administrator (still connected as an anonymous user) assigns to the server the same identification as the server the was the source for user export (using the Rename server utility from the System / Tools folder). Then the administrator imports users and leaves their passwords as they were.

If the new server has different identification then the old one and the passwords are not deleted, users won't be able to login successfully.