Repository database is Sybase 11, Bus Obj release 4.1.3.
I’m trying to pull together what should be a fairly simple report from the repository. I’m trying to get a list of all active Universes, with the users having access to each.
I know the data is in the Obj_M_Universes & the Obj_M_Actor tables, but I haven’t figured out the correct join (via the Obj_M_Repository??) between them.
Any assistance is appreciated. Either a semi-working Universe or free hand SQL is fine.
Thanks
Bruce E. Hinrichs
Schneider National, Inc.
Green Bay, WI USA
Repository database is Sybase 11, Bus Obj release 4.1.3.
I’m trying to pull together what should be a fairly simple report from the repository. I’m trying to get a list of all active Universes, with the users having access to each.
Bruce E. Hinrichs
Schneider National, Inc.
Green Bay, WI USA
It isn’t simple The link between actors and universes is in OBJ_M_RESLINK. This is a recursive table that describes the user hierarchy. You can download the Sybase universe at www.islink.com: click on ‘Download Here!’ followed by ‘Technical Notes’ on the left hand side. It uses auxilliary tables to denormalize OBJ_M_RESLINK.
I’ve sent Dave Rathburn (dungeonkeeper at www.islink.com) a new version, that uses triggers to keep the auxilliary tables in sync. I think it will available after this weekend.
The present version works fine, but you have to do the syncronization manually.
In a message dated 98-08-13 16:04:18 EDT, you write:
I’m trying to pull together what should be a fairly simple
report from the repository. I’m trying to get a list of all active Universes, with the users having access to each.
“Should be” is the hope, “Is not really” is the reality. :-0
I know the data is in the Obj_M_Universes & the Obj_M_Actor tables, but I haven’t figured out the correct join (via the Obj_M_Repository??) between them.
You also need to look at the OBJ_M_RESLINK to find a “link” between a user (Actor) and a universe (resource). The problems are:
Universes can be granted or revoked at a group or user level. Universes can be exported to the “top” level or a lower level of the group hierarchy.
Users can be in more than one group.
Universes can be granted / revoked in more than one group.
… and there is more, but that should be enough to help you realize the difficulty of answering a “simple” question.
Having said that, some one recently sent me a rough draft of a Sybase repository universe. I have not had the opportunity to set up a Sybase (or SQL Server) repository to test it out myself, but you may download it from our website at www.islink.com.
Any assistance is appreciated. Either a semi-working Universe or free hand SQL is fine.
To find the universe mentioned above, select the “Download Here” link once you get to our site. Look under BusObj Technical Documents. There is a link to email the original author of the universe if you have further questions or enhancement suggestions.
The link between actors and universes is in OBJ_M_RESLINK. This is a recursive table that describes the user hierarchy. You can download the Sybase universe at