Advanced Cleaning

In case of organizational changes or changing task allocations, the division into users and groups and the assignment of permissions and roles to these users and groups must be adapted. For example, changes of users and groups from external authentication systems such as Windows that are registered in Repository may require modifications of the repository database.

A repository database consists of 2 components: a User Management and a data component that contains the information about user- and group-specific settings, role assignments and permissions, and report catalogs. This division is required, because the User Management of a repository database can be used by other repository databases and their data objects. Therefore, for example, the deletion of a user or a group in a repository database and the deletion of the data objects that are associated with these user data in the same or other connected Repositories cannot be performed in one single step.

The Advanced Cleaning is a tool to determine whether user data and associated data objects are valid by analyzing and comparing the data of the repository databases, and to filter out objects that have an undefined status.

To clean up database objects, right-click the registration in the tree (there must be a connection) and select All Tasks > Advanced Cleaning. The dialog Advanced Cleaning opens. The dialog Advanced Cleaning includes five tabs that represent the steps to clean up database objects. You must perform the actions of the Advanced Cleaning that you start here for each connected repository database. The standard workflow to clean up database objects consists of these steps:

Checking in pending operations on database objects

Deleting user and group accounts (User Management)

Deleting obsolete users and groups

Deleting database objects of users and groups

Reviewing the log of the performed actions