BusinessObjects Board

Query on repsository showing groups along with their users?

security Supervisor (4.x - 6.x)
#1

I need to fire a query at the repository db that shows the groups along with their users.Oracle is the backend.

Thanks in Advance

vamsi krishna (BOB member since 2005-11-18)

#2

What version of BO are you using ? The following works for 6.5 and below

Try this:

SELECT 
  OBJ_M_ACTOR.M_ACTOR_C_NAME AS USERNAME,
  GROUPE.M_ACTOR_C_NAME AS USERGROUP
FROM 
  OBJ_M_ACTOR, 
  OBJ_M_ACTOR  GROUPE, 
  OBJ_M_ACTORLINK  OBJ_M_ACTORLINK2, 
  OBJ_M_ACTORLINK 
WHERE 
  ( OBJ_M_ACTOR.M_ACTOR_N_ID=OBJ_M_ACTORLINK.M_ACTL_N_ACTORID  ) 
  AND  ( OBJ_M_ACTORLINK2.M_ACTL_N_ID=OBJ_M_ACTORLINK.M_ACTL_N_FATLINKID  ) 
  AND  ( GROUPE.M_ACTOR_N_ID=OBJ_M_ACTORLINK2.M_ACTL_N_ACTORID  ) 
  AND  ( OBJ_M_ACTOR.M_ACTOR_N_TYPE=16  ) 
  AND  ( 
  OBJ_M_ACTOR.M_ACTOR_N_LAT  !=  1 
 )

Hope it helps

BO_Chief :us: (BOB member since 2004-06-06)

#3

Hi,

Informations on the security domain are available here

Regards