Hi,

I use JDBC as database authentication. I want to retrieve user attributes 
based on ID (int, not uid login ex: [email protected]), after logging in 
with [email protected], I hope CAS takes the user id (int).

With the following relationships:

*users (table)*
 - id (PK, int)
 - email
 - password


id    email            password
==============================================
*1*     [email protected]  **************
*2*     [email protected]  **************


*user_attributes** (table)*
 - id (PK, int)
 - user_id (FK, int)
 - attr_name
 - attr_value
 
id    user_id    attr_name        attr_value
==============================================
1     *1*          first_name       One
2     *1*          last_name        Example
3     *2*          first_name       One
4     *2*          last_name        Example

How to solve this? Thank you.

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/0f66f6e7-fa85-4105-a4ca-db83d907f49d%40apereo.org.

Reply via email to