Internal User

Table of contents

• 1 Function
• 2 Using the internal user
• 3 database configuration
• 3.1 changing database view permissions (optional)
• 3.2 MS SQL-Server configuration
• 4 configuration of IDL Konsis server

The IDL Konsis server uses needs only one account to connect to the database, ths is the internal user account.

Option: changing permissions of Database views:

• During the installation all permissions for the datebase views((select, insert, update, delete) are set to the role public. For the internal user a new role named KONSIS is created. The public rights of all views are revoked and granted to the new KONSIS role. Only the internal user should be assign to the konsis role.

The user/password for the internal user ist set by the configuration programm configure.exe for a specific database connection. (see: internet client / application server)

The view permissions can be changed with the programm ViewGranterGui. Start the programm ViewGranterGui in the directory \load of the IDL Konsis installation.

Enter the database conection infos and press search views the get a list of all Views that are granted to public. Now the permissions can be changed to the group in the Field grant group by pressing the changed grants button.

Important: This step must be done every time when a new release was installed. It's necessary because usually some views change or are created new. These views will have the default public permissions after installing a new release.

A new login account must be created as internal user. Add the user to the KONSIS role. The other user accounts are still needed for doing the windows authentication (single sign on) unless the authentication method IDL-User ist used.

• In the server configuration program(configure.exe) select auth: DB-User on the Database Configuration page.