Has anyone created /designed a security table. I just wanted to get an idea about how to go about it. ??
lucy.online 
(BOB member since 2012-04-03)
Come on Lucy, did you at least try a search?
Iāve found:
- Here on B
Bās Download section you can find Steve Krandelās presentation Using Designer to Implement Row-Level Security to get you started. - Row Level Security - Universe level
- Row Level Security (Best Practices ?)
- security question
- row level security - how to ?
And my recommendation (Oracle VPD e.g.) Object Level Security
Andreas 
(BOB member since 2002-06-20)
What i want is to Limit the customers to see the data pertaining to their own portfolioā¦
lucy.online (BOB member since 2012-04-03)
[quote:5ed98152b7=ālucy.onlineā]What i want is to Limit the customers to see the data pertaining to their own portfolioā¦
[/quote]
Did you read through the links?
:?
Mak 1 
(BOB member since 2005-01-06)
im doing it nowā¦
lucy.online (BOB member since 2012-04-03)
cool 
Marek Chladny 
(BOB member since 2003-11-27)
Say the reports are based on Location. By this I mean NY guy should see data for NY and CA guy should see the data for CA only.
Below is one way of designing the row level security.
Create a security table in the database which contains Locations and UserIDās. How to populate this security table is another story.
Once you have Users and their location, create a global filter in the Universe with the below logic;
There must be another location in your schema which can be used to filter the locations for the reportā¦
Schema.Location =
(SELECT
SECURITY.LOCATION
FROM
SECURITY.TABLE
WHERE
SECURITY.LOCATION=@VARIABLE(āBOUSERā)
This filter will be enforced for all the queries hitting this Universe with a filter on Locationā¦
when the query comes to this filter , it will execute the sub-query of this location filter first and pass the location of the User to the filter.
Getting my point?
AFAF 
(BOB member since 2012-07-13)