<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">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 class="e" id="q_10ff4dc733ab17a4_1"><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><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>