BusinessObjects Board

Security Repository Universe

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

Does any have or no where I can get a security repository universe. I want to create some security reports and wondered if anyone has done this before.

raydar (BOB member since 2003-08-28)

Need to know about SECURITY Universe
Security Repository Universe
#2

How about this one for starters?

Andreas :de: (BOB member since 2002-06-20)

#3

I looked at this one, but it does a good job of providing a universe to report on universes, it does not have the security side.

raydar (BOB member since 2003-08-28)

#4

I have one that Dwayne is getting posted soon. It reports on all that stuff. It started with an insight in the KX. It is designed for use with an Oracle repository on version 6. If youā€™re sql server or V5, weā€™ll have to chat.

Iā€™ve used it strictly to report on application permissionsā€¦those little traffic lightsā€¦but I think it will allow reporting on universe and document permissions as well. I havenā€™t studied or validated it.

Cindy Clayton :us: (BOB member since 2002-06-11)

#5

Cindy you can email to me at tom.ray@mediaocean.com

Thanks.

raydar (BOB member since 2003-08-28)

#6

Dwayne? I thought someone named BOB Downloads did that :smiley: . File is available for download here (link removed). The official posting to BOBā€™s downloads will probably get done tomorrow.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#7

Hi Cindy and Dwayne,

I downloaded this universe about 15 days ago and i believe I got the latest version bu Dwayne.

Cindy said:

I am on SQL Server and 6.1a. I made the changes in the Object definitions for SQL Server and all the objects Parse. The problem I am having is I am trying to get a report ā€˜who has access to which universeā€™ and the result i am getting doesnt reflect the previlages at the user level; rather it shows the prevs at the folder level which is used under ā€˜Inherited fromā€™.
My question is, can I get the information I need using this universe? If yes, what modifications should I make?

Thanks alot.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#8

Cindy, I downloaded the Auditor sample unv and reports from the BOB download area. Iā€™m new to BO so bare with me if my issues are elementary. I created the additional view successfully by running the sql script provided. I was also able to export the unv, but when doing a check there were several errors as listed below:

As I said, Iā€™m new to BO and SQL for that matter. I am using BO 6.5.1 with the Audit tables residing on a SQL 2000 db. When I try to run one of the reports in full client I get an illegal outerjoin error also. Thanks for any help or insight.

brewdude (BOB member since 2004-09-21)

#9

I believe all the stuff for this particular download was Oracle specific. Youā€™ll need to make is ā€œSQL Serverizedā€ before you can use it.

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

#10

Steve wrote:

Exactlyā€¦most of the divergences are using case statement instead of cascaded decode function, isNull() function instead of nvl() etcā€¦
I made all the changes and everything parsed. I am having problem with the level it inherits the previlages from, instead of doing it at the user level.

Iā€™d appreciate if someone can through some light on it.

thanks
kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#11

Youā€™ll have to elaborate. Iā€™m not sure what you mean.

Cindy Clayton :us: (BOB member since 2002-06-11)

#12

Thanks for your reply Cindy.
Lets say for a user some universes are disabled at the user level and in supervisor it shows like:

Unv Name Domain Inherited From

abc UnvTest EDW
xyz UnvTest IDEA

These universes are enabled at the folder/group levels they are inherited from, but disabled at the user level.
Using the security repository universe, when I run a report on who has access to which universe, I get the previlages set for a universe at the (inherited) folder level instead of the user level. So for these two universes I get a ā€˜1ā€™ eventhough the user doesnt have access to the universe.

I hope this made sense. Please advise me if I am doing something wrong or have to make some modifications to the views/universe.

thanks

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#13

It does make sense but Iā€™m not going to be any help at all. I never played around with the universe permissions, only module permissions. Sorry. :cry:

Cindy Clayton :us: (BOB member since 2002-06-11)

#14

Not a problem Cindy :slight_smile:
Iā€™ll play with it and if I come up with some modifications that will do it, iā€™ll post the SQL Server version on BOB Downloads :wink:

thanks

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#15

Thatā€™d be grand! :mrgreen:

Cindy Clayton :us: (BOB member since 2002-06-11)

#16

I think this may be slightly off the point of this Universe, but could someone point me towards a Universe that I could use to report on User Logins, Last Time Logged in, etc?

I think this is maybe what Auditor is for but donā€™t think my Company will be prepared to buy that.

If iā€™m barking up the wrong tree or there is nothing that can do this then please let me know.

Thanks very much,
Neil

Neil Phillips :uk: (BOB member since 2002-08-22)

#17

Hi Neil,

Youā€™re right you can find these informations using auditor. Only note that itā€™s only for e-BI activity i mean threw Webi.

Regards

#18

Is Auditor my only option then? Itā€™s expensive isnā€™t it (as per any BO product)?
I look at the website and get some details.
Thanks

Neil Phillips :uk: (BOB member since 2002-08-22)

#19

You can developp easily your own solution upon tables of the sec domain (OBJ_A*). A lot of companie made this :wink:

Regards

#20

We donā€™t have any of those tables in our repository at the moment, only OBJ_M*

Those tables come only with Auditor I think (OBJ_A*)

Am I correct in thinking this?

Neil Phillips :uk: (BOB member since 2002-08-22)