<div dir="ltr"><div>Justin,<br><br></div><div>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.<br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">This is a UTF-8 formatted mail<br>-----------------------------------------------<br>James C.-C.Yu<br>+886988713275<br></div></div>
<br><div class="gmail_quote">On 1 January 2015 at 03:50, Justin Richer <span dir="ltr"><<a href="mailto:jricher@mit.edu" target="_blank">jricher@mit.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>James,<br>
<br>
That should be fairly simple. This table is only used by the
Spring built-in "JdbcUserDetailsService", as specified in the
configuration here:<br>
<br>
<a href="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" target="_blank">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</a><br>
<br>
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:<br>
<br>
<a href="http://docs.spring.io/spring-security/site/docs/3.1.x/reference/springsecurity-single.html#nsa-jdbc-user-service" target="_blank">http://docs.spring.io/spring-security/site/docs/3.1.x/reference/springsecurity-single.html#nsa-jdbc-user-service</a><br>
<br>
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. <br>
<br>
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?<br>
<br>
-- Justin<div><div class="h5"><br>
<br>
On 12/31/2014 3:34 AM, James Yu wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>Hi there,<br>
<br>
</div>
I need to integrate MITREid-connect into my project
and find out I have table name conflict problem.<br>
</div>
MITREid-connect put username and password into a table
named "USERS" whereas "USERS" is already given to a
table in my project.<br>
</div>
I was expecting to see a table name assignment in model
entity such as <br>
@Table(name="user_info")<br>
</div>
in DefaultUserInfo.java<br>
<br>
</div>
However, I am unable to find the pattern of<br>
@Table(name="users")<br>
<br>
</div>
Please teach me how to rename "USERS" table for MITREid-connect,
thank you.<br>
<br>
<br>
<div>
<div>This is a UTF-8 formatted mail<br>
-----------------------------------------------<br>
James C.-C.Yu<br>
<a href="tel:%2B886988713275" value="+886988713275" target="_blank">+886988713275</a><br>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
mitreid-connect mailing list
<a href="mailto:mitreid-connect@mit.edu" target="_blank">mitreid-connect@mit.edu</a>
<a href="http://mailman.mit.edu/mailman/listinfo/mitreid-connect" target="_blank">http://mailman.mit.edu/mailman/listinfo/mitreid-connect</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div>