[mitreid-connect] how to change table name for USERS table?

James Yu cyu021 at gmail.com
Wed Dec 31 20:23:37 EST 2014


Justin,

Thanks for the heads-up, I didn't realize that I only need to add attribute
"users-by-username-query" to tag "security:jdbc-user-service" for renaming
the table.


This is a UTF-8 formatted mail
-----------------------------------------------
James C.-C.Yu
+886988713275

On 1 January 2015 at 03:50, Justin Richer <jricher at mit.edu> wrote:

>  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 listmitreid-connect at mit.eduhttp://mailman.mit.edu/mailman/listinfo/mitreid-connect
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/mitreid-connect/attachments/20150101/3d32be53/attachment.htm


More information about the mitreid-connect mailing list