[opencms-dev] Help getting the acegi user and role query working with opencms please....

[Mick Knutson]

Can someone help me with the Role Query???
SELECT username,role_name FROM user_role WHERE username = ?




and also tell me what the enabled verse dis-abled flag is for the cms_user
query???

SELECT username,password,enabled,email FROM app_user WHERE email = ?






On 1/5/07, Mick Knutson <mickknutson at gmail.com> wrote:
>
> And can anyone help me with the 2 queries I need:
>
> <property name="usersByUsernameQuery">
> <value>
> SELECT username,password,enabled,email FROM app_user WHERE email = ?
> </value>
> </property>
> ...
> <property name="authoritiesByUsernameQuery">
> <value>
> SELECT username,role_name FROM user_role WHERE username = ?
> </value>
> </property>
>
>
>
>
> On 1/5/07, Mick Knutson <mickknutson at gmail.com> wrote:
> >
> > Has anyone used Spring's ACEGI to secure opencms content?
> >
> > --
> > Thanks
> >
> > DJ MICK
> >
> > (Mick Knutson)
> > http://www.djmick.com
> > http://www.myspace.com/djmick_dot_com
> > http://www.thumpradio.com
>
>
>
>
> --
> Thanks
>
> DJ MICK
>
> (Mick Knutson)
> http://www.djmick.com
> http://www.myspace.com/djmick_dot_com
> http://www.thumpradio.com
>



-- 
Thanks

DJ MICK

(Mick Knutson)
http://www.djmick.com
http://www.myspace.com/djmick_dot_com
http://www.thumpradio.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20070108/5fe6420e/attachment.htm>