Queries for 5.1.7

[system]

Hi,
I need to get the universe rights per user/Group in BO 5.1.7. Can any one help by providing Queries to get the same?

I need to know the functionality of each tables in 5.1.7 repository. Can u pls. help me in this regard?

Thanks,
Bhuvan R

---

Bhuvan (BOB member since 2008-12-02)

[system]

Hi,

You can find the BO 5.1.x repository reference here:

BusinessObjects 5.1.x Repository Reference

As a convenience to our members, the repository reference from the "Freeware" folder on the BusinessObjects cdrom has been loaded on BOB's server. This is done per the copyright notice included within the files, specifically: [quote:d26b99425d="BusinessObjects Repository Reference"]PERMISSION TO USE THIS DOCUMENT IS GRANTED PROVIDED THAT (i) THE BELOW COPYRIGHT NOTICE APPEARS ON ANY AND ALL COPIES AND (ii) USE OF THIS DOCUMENT IS FOR INFORMATIONAL AND NON COMMERCIAL PURPOSES ONLY. BUSINESS OBJEC…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thanks Marek. I need to get the application rights for the users/Groups in BO 5.1.7. I would like to retrieve the application rights with the following information

1. User/Group name
2. ApplicationName
3. Net Access (View,View on Demand,Full Control, No Access)

In the link that you have sent, I’m not able to find the table which contains the application rights information. Is there a way to query the repository to retrieve the relevant info?

Kindly help me.

---

Bhuvan (BOB member since 2008-12-02)

[system]

Hi,

To be honest, I have not seen a query based on the BO 5.x/6.x repository that would do (in the full extent) what you need. It’s all because of the rights inheritance. Rights to objects/applications are inherited from the group(s) where a user belongs to. This makes the calculation of the net rights very complicated.

I believe that you could find some queries here in BOB but all of them (I think) are just approximations that do not give exact results.

---

Marek Chladny (BOB member since 2003-11-27)