5 Sep
2001
5 Sep
'01
7:07 p.m.
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