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)
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 (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 (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)