BusinessObjects Board

Users/Universe.

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

Hi,

I have built an universe on my repository tables based on the forum topic Security Repository Universe

When i pulled a report for on users/groups it’s workign fine. However if i pull a report on users/universe it’s not giving the correct results(It’s giving the all the users though the universe was disabled for some of the users in the repository). The below is the SQL generated by the report. Can any body through some light on this issue?

SELECT
UPPER(Bo_User.M_ACTOR_C_NAME),
Bo_Group.M_ACTOR_C_NAME,
NVL(Universe.M_UNI_C_FILENAME, ‘–’),
NVL(Universe.M_UNI_C_LONGNAME, ‘----’)
FROM
OBJ_M_ACTOR Bo_User,
OBJ_M_ACTOR Bo_Group,
OBJ_M_UNIVERSES Universe,
OBJ_M_ACTORLINK Group_Link,
OBJ_M_ACTORLINK User_Link,
OBJ_M_RESUNION_UNV UNION_UNV,
OBJ_M_RESMINLEVEL_UNV MINLEVEL_UNV
WHERE
( Universe.M_UNI_N_LAT<>1 )
AND ( MINLEVEL_UNV.M_ACTL_N_ID=User_Link.M_ACTL_N_ID )
AND ( User_Link.M_ACTL_N_ACTORID=Bo_User.M_ACTOR_N_ID )
AND ( User_Link.M_ACTl_N_LAT <>1 )
AND ( Bo_User.M_ACTOR_N_LAT<>1 )
AND ( Universe.M_UNI_N_ID=UNION_UNV.M_RES_N_RESID )
AND ( UNION_UNV.M_ACTL_N_ID=MINLEVEL_UNV.M_ACTL_N_ID and UNION_UNV.M_RES_N_RESID=MINLEVEL_UNV.M_RES_N_RESID and UNION_UNV.M_RES_LEVEL=MINLEVEL_UNV.M_RES_MINLEVEL )
AND ( Group_Link.M_ACTL_N_ACTORID=Bo_Group.M_ACTOR_N_ID )
AND ( Bo_Group.M_ACTOR_N_LAT <>1 )
AND ( Bo_Group.M_ACTOR_N_TYPE=1 )
AND ( User_Link.M_ACTL_N_FATLINKID=Group_Link.M_ACTL_N_ID )
AND ( Bo_User.M_ACTOR_N_TYPE=16 )
AND ( Group_Link.M_ACTl_N_LAT <>1 )
AND (
NVL(Universe.M_UNI_C_FILENAME, ‘–’) = @variable(‘Select a Universe’)
)

Thank You.

psrbobj :india: (BOB member since 2006-10-02)

#2

This tells you that the universe is linked to the user. Even if it’s disabled, it’s still linked.

The best-practice is only to link universes that people actually are allowed to use.

I’ll look around, but there is another flag you’re going to need.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

Thank You - Steve.

In which repository table i can find the disable/enable information of a universe/report for a particular user.

Thanks

psrbobj :india: (BOB member since 2006-10-02)

#4

It’s not in a table. It’s in a series of tables. This information is virtually impossible to retrieve from the repository due to the recursive nature of the OBJ_M_ACTOR and OBJ_M_ACTORLINK tables.

Steve Krandel :us: (BOB member since 2002-06-25)