[mitreid-connect] how to change table name for USERS table?
Justin Richer
jricher at mit.edu
Wed Dec 31 14:50:30 EST 2014
James,
That should be fairly simple. This table is only used by the Spring
built-in "JdbcUserDetailsService", as specified in the configuration here:
https://github.com/mitreid-connect/OpenID-Connect-Java-Spring-Server/blob/master/openid-connect-server-webapp/src/main/webapp/WEB-INF/user-context.xml#L34
The table itself is defined by Spring as a default for this bean, and so
we pack that one in for simplicity. You can continue to use that bean
with a different table if you override the queries, as described here:
http://docs.spring.io/spring-security/site/docs/3.1.x/reference/springsecurity-single.html#nsa-jdbc-user-service
And of course change your DB schema to have the user information in
another table. Alternatively, you can create a custom user details
service bean to call your tables or services directly, which is what
other large deployments do. Most major deployments don't use the
built-in user details component and instead use a different mechanism
for user information, usually custom to the installation.
Out of curiosity, what is your project that it already has a user store
and yet you're integrating it directly with the ID server?
-- Justin
On 12/31/2014 3:34 AM, James Yu wrote:
> Hi there,
>
> I need to integrate MITREid-connect into my project and find out I
> have table name conflict problem.
> MITREid-connect put username and password into a table named "USERS"
> whereas "USERS" is already given to a table in my project.
> I was expecting to see a table name assignment in model entity such as
> @Table(name="user_info")
> in DefaultUserInfo.java
>
> However, I am unable to find the pattern of
> @Table(name="users")
>
> Please teach me how to rename "USERS" table for MITREid-connect, thank
> you.
>
>
> This is a UTF-8 formatted mail
> -----------------------------------------------
> James C.-C.Yu
> +886988713275
>
>
> _______________________________________________
> mitreid-connect mailing list
> mitreid-connect at mit.edu
> http://mailman.mit.edu/mailman/listinfo/mitreid-connect
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/mitreid-connect/attachments/20141231/4f1edb3c/attachment.htm
More information about the mitreid-connect
mailing list