Database (RDBMS)

Identity Source:
  Name: user-database
  Type: Database (JDBC)

  Connection:
    Driver: org.postgresql.Driver
    URL: jdbc:postgresql://db.example.com:5432/users
    Username: josso_app
    Password: [encrypted]
    Pool Size: 10

  Queries:
    User Query: >
      SELECT id, username, email, password_hash,
             first_name, last_name, enabled
      FROM users WHERE username = ?

    Roles Query: >
      SELECT r.name FROM roles r
      INNER JOIN user_roles ur ON r.id = ur.role_id
      WHERE ur.user_id = ?

  Password Encoding:
    Algorithm: bcrypt
    Strength: 12