Reset script for river rights

This document provides information Administrators about the effects of the current update on Riversuite user rights and describes procedures for resetting rights if necessary. It is not intended for end users, but exclusively for internal administrators and support teams.

Background

As part of the database separation of Riverbird and c-entron, rights that are no longer required in the c-entron database were deactivated with the release of 2.0.2509.xx.
These rights can still be viewed as "deactivated rights" in rights management

rights affected:

• Separate databasesif the Riversuite and c‑entron databases are already disconnected, no action is required.

• Non-separate databasesin this case, all Riversuite rights as "deactivated", then "reactivate" the rights to manage with the following SQL script:

UPDATE SichrechSET Obsolete = 0 WHERE I3D IN (20800015, 20800016, 20800026, 20800027, 20800047, 20800048, 20800049, 20800090, 20800091, 20800103, 20800105, 20800114, 20800115, 20800116, 20800117, 20800118, 20800131, 20800132, 20800133, 20800057, 20800058, 20800059, 20800060, 20800062, 20800087, 20800063, 20800064, 20800055, 20800056, 20800065, 20800066, 20800067, 20800068, 20800069, 20800070, 20800071, 20800072, 20800080, 20800081, 20800110, 20800083);

Recommendation

• Before executioncreate a backup of the database.

• After executioncheck whether all necessary rights are active again.

• Long term: If possible, a clear separation between Riversuite and c‑entron databases to avoid future conflicts. Here are the instructions: Disconnect databases