cancel
Showing results for 
Search instead for 
Did you mean: 

Row-Level Security with Universes

Former Member
0 Kudos

Could someone explain how I could accomplish row-level security within a Universe. I know within a Business View you have the ability to use a variable that captures the login ID of the current user and use that ID as a variable within the WHERE condition of a filter.

e.g.

SELECT *

FROM TABLE

WHERE ID =

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

SELECT *

FROM TABLE

WHERE User = @Variable('BOUSER')

Variable BOUSER has the current user who has logged in.

Former Member
0 Kudos

Go to the controls tab of the Universe Parameters box

there u could find four options

first option is the row-level restriction there we have to mention the no.of.rows

k if theres anything wrong plzz let me know

Sreenivas