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.
- 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.
- 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.
