Custom SQL Queries for Authorization

If you have an existing database in use that has a structure in place for managing users, roles, and rights but this is incompatible with RapidClipse’s standard approach, as an alternative, you can define two SQL queries.

1. Define an SQL statement for users and roles, which returns a result with two columns. On the left side all users, on the right the corresponding role. Do not use a GROUP BY function for that.
2. Define an SQL statement for roles and rights, which returns a result with two columns. On the left side all the roles on the right side the related rights. Do not use a GROUP BY function for that.