BusinessObjects Board

Row level Security on Universe in XI R3.1

building semantic layer
#1

Hi,

I’m new to universe.
We are implementing row level security on our universes.
1)We have one universe in SQL and other in Oracle databse. Can we have a security table built in common for both?
2)If so in which database should the security table be placed? For eg, if the security table is placed in SQL db, how can I access the same from Oracle based universe?

Kindly help me.

Thanks in Advance

rajeeva :us: (BOB member since 2009-04-26)

Security and User creation
Row Level Security (Best Practices ?)
#2

Hi

I’m implementing row level security in Universe in XI r3.1
I have below questions

  1. Should I create the security table in db and insert the same in universe or Is there a way we can create a security table in universe itself?

2)What are all the columns to be created in security table? For eg, if I have restrictions on DepID, should this DepID be created as a column in Security table?

  1. In that case should I join this DepID to same column fact table?

rajeeva :us: (BOB member since 2009-04-26)

#3

Merged both the topics as they both talk about row level security. Thanks.

Jansi :india: (BOB member since 2008-05-12)

#4

I would recommend putting the security table in the database, it is a more robust solution.

You can, of course, apply this restriction, on the table, using BOXI security from within the universe, itself.

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Thanks for your reply Mak.

As you said applying restriction in universe can be for simple security settings, when the setting is complex, I feel going through table would be better. Kindly let me know your view/suggestions.

Also kindly help me if you have knowledge in security table area. Please tell me how should I built the table and access the same in universe and apply restriction.

Thanks,
Jeeva

rajeeva :us: (BOB member since 2009-04-26)

#6

I already stated the database solution is better…:).

Search is your friend:-

https://bobj-board.org/t/117907

Mak 1 :uk: (BOB member since 2005-01-06)

#7

Hi Mak,

I need help in following questions

1)We have one universe in SQL and other in Oracle databse. Can we have a security table built in common for both?
2)If so in which database should the security table be placed? For eg, if the security table is placed in SQL db, how can I access the same from Oracle based universe?

Thanks for your response.
:mrgreen: Raja[/quote]

rajeeva :us: (BOB member since 2009-04-26)

#8

If you have data federator this may be possible.

Unless there is some kind of DB link that would allow this, it is not possible.

Seeing, what you want is quite basic, i.e. a straight select of users and other attributes, you may be able to have one ETL routine that is capable of feeding both databases…

Mak 1 :uk: (BOB member since 2005-01-06)