DQL Query - know groups and users

danonino

I wanted to know how can I make the DWL query to know the "user-groups" assignment. I´ve tried with this query:

select us.user_name, us.user_group_name
from dm_user us, dm_group gr
where gr.group_name=us.user_group_name

but I´m sure it´s wrong because it uses repeating attributes, and I want to see all the groups where is assigned every user, I don´t remember how to do it...Some users can have two or more groups, how can I do it??

witchedwiz

using this query as a starting point

select group_name from dm_group where any i_all_users_names = ‘username’

you can easily come up with something (with this you get direct groups and subgroups for the username you choose)

you can come up with a query easily, but i'd strongly avoid using a query that does the same thing for each and every user, it would produce a huge amount of data in an heavily populated repository..

say you do something like

select dm_user.user_name, dm_group.group_name from dm_name, dm_group where any dm_user.i_all_users_names = ‘username’ and dm_user.group_name = dm:group.group_name

cross finger for i can't test it in dql but it should do what you want