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

[Mick Knutson]

select u.user_name, g.group_name
from cms_users u,
          cms_groups g,
           cms_groupusers gu
where user_name = ?
and u.user_id = gu.user_id
and gu.group_id = g.group_id




On 1/8/07, Mick Knutson <mickknutson at gmail.com> wrote:
>
>
> 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




-- 
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/20070109/f191ef49/attachment.htm>