Access Leavel Restriction

[Former Member]

Hi

Can any body explain types of access leavel security implement in boxir2.

Thanks in advance

[Former Member · Accepted solution]

Access levels is nothing but set of security settings that can be applied on a set of user(s)/Group(s)

These restrictions can be applied on the following things

Connections --id you have two dbs DB1,DB2 and the default connection points DB1 but if you want to point the universe to DB2 if certain user logs then that can be set here

Controls-here you can set certain query limits like no of rows,execution time

SQL -you can restrict the user to use certain functionality like sub queries, cross joins etc

Objects -you can avoid the user from accessing certain objects

Table Mapping-This is used for replacing a default table with another table based on the user who logged into the infoview

Rows --You can apply filter on the columns so that the user will see only the selected data

see below example

1) Universe -> Tools -> Manage Security -> Manage Access Restrictions

2) Select u201CCreate New Restrictionu201D -> Rows -> Add -> Select the table on which you want to apply the restriction (this table should contain users information) and in the where clause put the condition on the column on which you want to implement security=@variable(u2018BOUSERu2019)

3) Apply this restriction to the users/groups to which you want to impose and export the universe

4) For example if we have users with country name and if we login to the infoview with these user names and creates a report then we can see the data related to country with which we logged in

5) The query will be generated like below

SELECT

Country.country_id,

Country.country

FROM

Country

WHERE

( Country.country=@variable('BOUSER') )

6) During run time it replaces @variable(u2018BOUSERu2019) with the user who logged in to the infoview

Ex: if we login with UK user then query will be

SELECT

Country.country

FROM

Country

WHERE

( Country.country='UK' )

Note: With this approach the restriction will be applied to all the reports which are based on this table for the users to whom the restriction is applied

Refer Universe designer guide for more detailed information

Edited by: bolearner on Jun 21, 2011 12:31 PM