Secure Login

How to login to Aurea CRM database securely.

A separate administration program is available that allows you to generate SQL source code for Microsoft SQL or Oracle database, in order to configure secure logins for your Aurea CRM database.

1. Contact support@aurea.com to obtain the necessary key_admin.exe and mmkey2.dll files.
2. Copy these files to the \system\exe directory.
3. Enter the following command line:

   key_admin [mss|ora] [-prefix:TABLE_PREFIX]

   mss|ora is the database in use (MS SQL oder Oracle)

   TABLE_PREFIX is the desired table prefix

   Note: key_admin.exe writes to stderr. Append 2>file.txt to the command line to pipe the output to file.
4. Enter the desired database user's login and password. This user requires full access to the database.
5. Create the stored procedure and table in the database using this user name.
6. Enter the generated record in the tables.
7. Assign access to only this stored procedure (i.e. not to all tables in the database) to users in the mmdb.ini file.
8. To use the stored procedure, enter the following in the mmdb.ini file:

   [secure_login]

   sl=1

   Note: Other values of sl disable the secure login.