User Group in ASP

sdk development
1

I am currently distributing BO reports as pdf’s and using the BO Webi login to gain access. I wish to have different levels of access to the reports dependent on the group the user account is created in supervisor.

I am trying to grab the usergroup of a user in a ASP page. Does anyone have VB code to do this?

Ken

ceekb :australia: (BOB member since 2003-09-02)

2

Found that group can be obtianed from a query on the repository DB.

SELECT
  OBJ_M_ACTOR.M_ACTOR_C_NAME,
  OBJ_M_ACTOR2.M_ACTOR_C_NAME
FROM
  OBJ_M_ACTOR  OBJ_M_ACTOR2,
  OBJ_M_ACTORLINK  OBJ_M_ACTORLINK2,
  OBJ_M_ACTOR,
  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_ACTORID=OBJ_M_ACTOR2.M_ACTOR_N_ID  )
  AND  ( OBJ_M_ACTORLINK.M_ACTL_N_FATLINKID=OBJ_M_ACTORLINK2.M_ACTL_N_ID  )

It’s not very tidy but it works. If anyone has a better way using the BO SDK or a tidier query please let me know.

Ken :?:

ceekb :australia: (BOB member since 2003-09-02)