How do I get sub-groups of group that person directly under

security Supervisor (4.x - 6.x)
1 
select a.m_actor_c_name group_name 
from obj_m_actor a, obj_m_actorlink l 
where m_actor_n_type = 1 
and a.m_actor_n_id = l.m_actl_n_actorid 
and l.m_actl_n_id in (select l.m_actl_n_fatlinkid 
from obj_m_actor a, obj_m_actorlink l

I get user and the group that person is directly under. I need a litle more detail…

How do I find out the higher level groups?

For instance:

Group_1
Group_1A
User_1

How can I show that user_1 is under Group_1a which is under Group_1?

Thank you,

JA

johndawg :us: (BOB member since 2004-07-09)