Hi,

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

With the following relationships:

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


id    email            password
==============================================
*1*     o...@example.com  **************
*2*     t...@example.com  **************


*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 cas-user+unsubscr...@apereo.org.
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