Can you query the database for the roles? If so, you can use the expert mode of the database authentication where you specify three queries:
- Authentication query
- Role List Query
- User’s Roles Query
Rather than using the table structure Ignition expects.