Central management of the entire rule base
All data access rules are now concentrated at a single location and are available for processing. We have capitalized on this opportunity by developing a comprehensive solution called Regelwerk.com "Studio" for the configuration, steering and control of the rule set.
This software tool opens up entirely new possibilities for creating, changing, adjusting, reusing, testing, controlling and even auditing data access rules and policies. Furthermore, it lets you easily browse through the database tables, the roles and users and the corresponding rules from any perspective.
The following screenshot of the "Studio" shows our live-demo application:
Browse, know, control
- Which role/identity has which functional access to which data field? - This applies to all create/read/update/delete or CRUD operations.
- Who is allowed to access a certain database table under what conditions (e.g. time)?
- Which projections (view of a database table row) can the role "Executive Management" access without any restrictions?
- In short: data access rules are completely transparent.
Never before has it been so easy to get a full overview of even the most complex rule sets by a few simple clicks. We will continuously capitalize on the enormous potential for detailed reporting, controlling and auditing.
The raw material, database tables, roles and identities or users can be loaded into the "Studio". Import functions are already available for databases and will be further enhanced.
Once ready, the so-called CRUD Matrix (see below) can be used as a first step, even by non-technical users, to allocate access rights to tables (vertical) and all users/identities (horizontal).
The detailed rules for the affected fields can then be implemented in standard SQL syntax. This applies to the simplest "1 = 1" up to the most complex conditions including "and/or" linking.
All adaptations and renewals of tables, rules and roles/identities can be implemented "on-the-fly" and transferred in a well-controlled manner to the live system for immediate execution.
Thanks to the latest Eclipse RCP technology, the graphical user interface is highly configurable and can be flexibly adjusted to the needs of our customers and their user groups.