• Home
• pl.fhframework.core.security.provider
• securityDataProvider-jdbc
• 4.9.25
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

k.core.security.provider.securityDataProvider-jdbc.4.9.25.source-code.security-provider.properties Maven / Gradle / Ivy

# JDBC SECURITY DATA PROVIDER
# Query for user name, password and is active flag
fhframework.security.provider.jdbc.query.users=SELECT login, password, NOT(blocked OR deleted) FROM SEC_USER_ACCOUNTS WHERE login = ?
# Query for user roles (only top level roles)
fhframework.security.provider.jdbc.query.user-roles=SELECT ua.login, COALESCE(br.role_name, '-- NONE --') FROM SEC_USER_ACCOUNTS ua LEFT OUTER JOIN SEC_ROLE_INSTANCES ri ON ri.USER_ACCOUNT_ID = ua.ID LEFT OUTER JOIN SEC_BUSINESS_ROLES br ON br.ID = ri.BUSINESS_ROLE_ID WHERE ua.LOGIN = ?