Database Configuration | GBG IDscan Documentation

Although the database tasks are part of the installation, a Database Team should perform the tasks mentioned below.

The database installation tasks include the following:

Configuration Modifications
Users, Groups, Roles and their Privileges
Database Creation

Depending on a user’s database management system, settings related to the database can be configured in different ways.

The following configurations should be applied if the system is going to be used with MSSQL Server. If you require an Oracle Server please see the last part of this chapter.

Steps to encrypt/decrypt:
https://deployment.idscanbiometrics.com/IEOS/dbscripts/IEOSMultiTenancy/MSSql/demo.txt

UpdateSchemaAndEncryptOldData:
https://deployment.idscanbiometrics.com/IEOS/dbscripts/IEOSMultiTenancy/MSSql/UpdateSchemaAndEncryptOldData.txt

ExistingIEOSMultiTenancy:
https://deployment.idscanbiometrics.com/IEOS/dbscripts/IEOSMultiTenancy/MSSql/ExistingIEOSMultiTenancy.txt

IEOSMultiTenancyCreation:
https://deployment.idscanbiometrics.com/IEOS/dbscripts/IEOSMultiTenancy/MSSql/IEOSMultiTenancyCreation.txt

AlterStoreProcedure:
https://deployment.idscanbiometrics.com/IEOS/dbscripts/IEOSMultiTenancy/MSSql/AlterStoreProcedure.txt