Data Source Auth Service - User Based login Auth Service with Roles

The Data Source Auth Service is an authentication service which retrieves user roles from the database using the username and password.

To create a user-based login Auth Service to validate from given user account table:

  1. Click + under settings and Create a new Data Source Auth Service.

  2. Enter the Name for Auth and Select Type as Data Source Auth Service.

  3. Click OK.

    Image 1

  4. Navigate to Properties Panel of Newly created Auth Service.

  5. Click Properties > Authentication Instruction to enter the new SQL Instruction to validate the user. Open the editor.

    Image 2

  6. Write the SQL Instruction and click OK.

    Image 3

  7. Select the Data Source for given SQL Instruction from Properties > Authentication Data Source.

    Image 4

  8. Click SAVE.

    Image 5