Predefined command to get BO Group name

HI
Is there a pre-defined key word like BOUSER to get the BO Group name.
if not is there any way to get the name of the group a user belongs to from getting the loginID

Thankyou.


cheedalla (BOB member since 2004-04-13)

You may have trouble, given that users can belong to more than one group. Can’t you use the Supervisor module and check the group membership of a sepcific user?

Hi Mark

My users are unique,I am trying row level restrictions which are driven by the group name.


cheedalla (BOB member since 2004-04-13)

I am not exactly sure what you ultimately want to do with this information (meaning I am not sure if the SQL will help) but see if this code helps you at all. fyi - it was generated from a BO report based on a audit universe available in the downloads. you may have to play with it a little but hope it helps.

SELECT
  OBJ_M_ACTOR.M_ACTOR_C_NAME,
  OBJ_M_ACTOR_link.M_ACTOR_C_NAME
FROM
  OBJ_M_ACTOR,
  OBJ_M_ACTOR  OBJ_M_ACTOR_link,
  OBJ_M_ACTORLINK  OBJ_M_ACTORLINK_link,
  OBJ_M_ACTORLINK
WHERE
  ( OBJ_M_ACTORLINK.M_ACTL_N_ACTORID=OBJ_M_ACTOR.M_ACTOR_N_ID  )
  AND  ( OBJ_M_ACTORLINK.M_ACTL_N_FATLINKID=OBJ_M_ACTORLINK_link.M_ACTL_N_ID  )
  AND  ( OBJ_M_ACTORLINK_link.M_ACTL_N_ACTORID=OBJ_M_ACTOR_link.M_ACTOR_N_ID  )
  AND  ( OBJ_M_ACTOR.M_ACTOR_N_LAT != 1  )

jswoboda :us: (BOB member since 2002-06-20)

I do not know of a predefined key word that does this. But I implement row level security by querying the repository. I retrieve a list of the groups a user belongs to.

One downside to this approach is the possibility of the repository design changing in future versions.


Crash :us: (BOB member since 2004-04-27)

I am using this to get the group name (from BO Techsupport )

SELECT M_ACTOR_C_NAME FROM OBJ_M_ACTOR
WHERE M_ACTOR_N_ID = (SELECT M_ACTL_N_ACTORID FROM OBJ_M_ACTORLINK
WHERE M_ACTL_N_ID = (SELECT M_ACTL_N_FATLINKID FROM OBJ_M_ACTORLINK
WHERE M_ACTL_N_ACTORID = (SELECT M_ACTOR_N_ID FROM OBJ_M_ACTOR WHERE M_ACTOR_C_NAME = @variable('BOUSER") ) ) );

as this is greater then 256 charcters I created function,But now how can i call a function in the Supervisor where clause.


cheedalla (BOB member since 2004-04-13)