[Zope] GUF & SQL login problems

Milos Prudek milos.prudek@worldonline.cz
Wed, 05 Sep 2001 21:07:07 +0200


> > select groupname    from groups,
> > users, user_group_map    where        users.username = 'milos'
> > and        users.user_id = user_group_map.user_id     and
> > groups.group_id = user_group_map.group_id
> 
> Issuing this statement manually, what do you get?
> Does it return roles with sufficient priviledges?


The result of this statement is:
 groupname
-------
 mygroup
(1 row)

The statement returns name of group.

How does groupname relate to role?


Contents of my users table:
user_id      username   password
1            milos      secret

Contents of my groups table:
group_id    groupname
1           mygroup

Contents of my user_group_map table:
user_id     group_id
1           1

--
Milos Prudek