Could you please tell me the query which I can used against repository to get the list of universe and the users which has access to each of these universe
Basically, I need list of universe with it assciated users
Thanks.
godgift 
(BOB member since 2004-07-09)
Which version?
MichaelWelter 
(BOB member since 2002-08-08)
Indeed, the repository structure for legacy version of BusinessObjects is substantially different than for XI. So – a word to the wise – always tell the board which version you are using.
Also, have you tried a Search?
Anita Craig 
(BOB member since 2002-06-17)
I am using Business Objects 6.5.1
And yes I searched the forum for 1+ hour with no luck.
Regards.
godgift (BOB member since 2004-07-09)
BOB’s Downloads has a Security Repository Universe for version 6, for Oracle, for starters.
There’s another download for 6.5.1 Repository universe for User/Group/Document & BCA .
Anita Craig (BOB member since 2002-06-17)
Thank you for the reply. I have a little problem though. My repository lies in DB2 and my requirement is bit urgent.
Could you please give me the query using which I can fetch these information
Regards.
godgift (BOB member since 2004-07-09)
You’ll have to make some minor modifications to the universe available here, in order to make it work with DB2. I’ve not worked with DB2, so I don’t have the SQL statement available to get what you want.
MichaelWelter (BOB member since 2002-08-08)
Thank you for the response. I will try to build the query, and If i get it correctly, I will post the query here for future references.
Regards.
godgift (BOB member since 2004-07-09)