<< Click to display table of contents >> Navigation:  Administration > Security settings > Securing Database Access > Activating the application role

The Application Role „TiConAppRole“ has already been created in the database by MTM and is password-protected. This role is inactive by default. To use it, the Application Role must first be activated.

Procedure for Case 1: New database (as of and including TiCon 4.09)

▪Use a user in the connection string who does not have read/write access.

▪Activate the users of the AppRole via config.xml by adding: <config name="db.useAppRole" value="true" />

Procedure for Case 2: Old database (prior to TiCon 4.09)

▪In the connection string, use a user with the following permission „db_owner“.

▪Perform the conversion using the tool ticon4converter.exe or start TiCon once.

▪Next, revoke the DB user's permissions, or use a different user who does not have read/write access to access the TiCon database.

▪Activate the users of the AppRole by adding: <config name="db.useAppRole" value="true" /> to the config.xml.

More about this:

Data Conversion