User-defined SQL queries for authorization

If you are using a database that already has a structure for managing users, roles, and privileges that is not compatible with the RapidClipse standard concept, you can alternatively define 2 SQL queries.

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

  2. Define a SQL statement for roles and rights that returns a result with 2 columns. On the left side all roles, on the right side the corresponding rights. Do not use a GROUP BY function for this.
    Image not found