BusinessObjects Board

Row level security !

building semantic layer
#1

How can I know in detail about row level security ? Is there any documentation or link for this ??

Thanks

HK1979 (BOB member since 2007-05-18)

#2

For BO 6.x:
Have a look at the BO documentation, file deployment.pdf, page 446.

This PDF is accessible from Supervisor’s menu Help -> Deployment Guide.

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

#3

Here is a pretty good link … the BOB search page. Just type in “row level security” and you’ll find plenty of detail. You may also find this presentation useful.

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

#4

BTW, is it done at universe level or in supervisor/cmc ?

Thanks

HK1979 (BOB member since 2007-05-18)

#5

In XI it is done in Designer or as an alternative at the database level (for example VPD/Virtual Private Database in Oracle), which is transparent to Business Objects.

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

#6

One more thing is what is the difference between row level security and object level security ?

Where to read for this ?

Thanks

[Moderator Edit: Why do you put Exclamation Points in almost all of your topic headings? :!: ]

HK1979 (BOB member since 2007-05-18)

#7

Row level security means you can see certain rows, for example all transactions taking place in the UK, but no transactions in any other country. You will be able to create a report using the measure “transaction amount” and the dimension “country of transaction”. The row-level restriction is implemented by adding a WHERE clause to the executed SQL clause, for example:

SELECT SUM(Transactions), Country
FROM Table
WHERE Country = ‘UK’
GROUP BY Country

Object level security grants/denies you access to universe objects, so you might have a user who cannot use/see the measure “transaction amount” at all, period.

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

Row level security