Row Level Security

[former_member540424]

What is the use of Row level security?
How to apply that?

[Former Member · Accepted solution]

Hi,

Row level Security is used to limit the rows of data for a user/group.We can implement this using Universe Designer.There is a two way to achieve this.

1.We can use @variable('BOUSER') in where condition area of object definition.

2.We can also use "Manage Access Restriction" Option in Universe Designer.In Designer,Go to Tools-->Manage Security-->Manage Access Restrictions--> Specify the Name to Restriction-->In Row tab(Select table and give the condition)-->Assign this restriction to the user/group.(This restricts a user to access values corresponding to the specified condition.

Hope this will be helpful.

Regards,

Amala.S

[Former Member]

Hi,

Refer this link about Row level Security.

http://www.youtube.com/watch?v=6yM0OLK6QlI

[former_member182521]

Gowri,

You can apply row level security at universe level.

Have a look here for the versions XI R2 & XI 3.x

http://www.dallasmarks.org/presentations/SBOUC2007_Dallas_Marks_Secure_Universes_Using_Restriction_S...

Regards,

Mani

[Former Member]

Hi Gowri

Row level security is usually done to secure data from users on accessing what rows/columns of data can be used. They are primarily used when dealing with large number of users accessing same data but with different functionality levels, say from top management to employee.

This is mostly known as Object Level Security in Business Objects. They are created using Universe designer. Also has more additional features to restrict users.

This can be set to implemented in different ways but since i cannot provide you whole screenshots, i give a link which will show how to create one.

http://www.dataspace.com/Downloads/IA_Final_MD.pdf

Hope this helps.