select u.user_name, g.group_name<br>from cms_users u,<br>          cms_groups g,<br>           cms_groupusers gu<br>where user_name = ?<br>and u.user_id = gu.user_id<br>and gu.group_id = g.group_id<br><br><br><br><br><div>
<span class="gmail_quote">On 1/8/07, <b class="gmail_sendername">Mick Knutson</b> <<a href="mailto:mickknutson@gmail.com">mickknutson@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Can someone help me with the Role Query???<br><span style="font-weight: bold;">
SELECT username,role_name FROM user_role WHERE username = ?<br><span style="font-weight: bold;"><br><br><br><br></span></span>and also tell me what the enabled verse dis-abled flag is for the cms_user query???<br><br><span style="font-style: italic;">


SELECT username,password,</span><span style="font-weight: bold; font-style: italic;">enabled</span><span style="font-style: italic;">,email FROM app_user WHERE email = ?</span><br><br><span style="font-weight: bold;"></span>

<br><br><br><br><br><div><span class="gmail_quote">On 1/5/07, <b class="gmail_sendername">Mick Knutson</b> <<a href="mailto:mickknutson@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
mickknutson@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
And can anyone help me with the 2 queries I need:<br><br>
        <property name="<span style="font-weight: bold;">usersByUsernameQuery</span>"><br>
            <value><br><span style="font-weight: bold;">
SELECT username,password,enabled,email FROM app_user WHERE email = ?</span><br>
            </value><br>
        </property><br>...<br><property name="<span style="font-weight: bold;">authoritiesByUsernameQuery</span>"><br>
            <value><br><span style="font-weight: bold;">
SELECT username,role_name FROM user_role WHERE username = ?</span><br>
            </value><br>
        </property><div><span><br><br><br><br><br><div><span class="gmail_quote">On 1/5/07, <b class="gmail_sendername">Mick Knutson</b> <<a href="mailto:mickknutson@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

mickknutson@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Has anyone used Spring's ACEGI to secure opencms content?<br clear="all"><br>-- <br>Thanks<br><br>DJ MICK <br><span><br>(Mick Knutson)<br><a href="http://www.djmick.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">


http://www.djmick.com</a><br><a href="http://www.myspace.com/djmick_dot_com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.myspace.com/djmick_dot_com</a><br><a href="http://www.thumpradio.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.thumpradio.com</a>

</span></blockquote></div><br><br clear="all"><br>-- <br>Thanks<br><br>DJ MICK <br><br>(Mick Knutson)<br><a href="http://www.djmick.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.djmick.com
</a><br><a href="http://www.myspace.com/djmick_dot_com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.myspace.com/djmick_dot_com
</a><br><a href="http://www.thumpradio.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.thumpradio.com</a>

</span></div></blockquote></div><br><br clear="all"><br>-- <br>Thanks<br><br>DJ MICK <br><span class="sg"><br>(Mick Knutson)<br><a href="http://www.djmick.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.djmick.com</a><br><a href="http://www.myspace.com/djmick_dot_com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.myspace.com/djmick_dot_com</a><br><a href="http://www.thumpradio.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.thumpradio.com</a>

</span></blockquote></div><br><br clear="all"><br>-- <br>Thanks<br><br>DJ MICK <br><br>(Mick Knutson)<br><a href="http://www.djmick.com">http://www.djmick.com</a><br><a href="http://www.myspace.com/djmick_dot_com">http://www.myspace.com/djmick_dot_com
</a><br><a href="http://www.thumpradio.com">http://www.thumpradio.com</a>