Row level security not working

[former_member185138]

Hi Experts,

We have identical schemas for 2 companies.

We are using same IDT and report for both the companies and created following mandatory @prompt to select the company name and assign as table owner every time a report is refreshed.

Now the requirement is that users from company 1 should only see 1 in the prompt list.

So I added following row restriction.

But when I am refreshing the report and prompt I see both the company name so the row level restriction and where clause in not added in the query.

I have applied this to everyone group and checked also.

Can you please suggest what I am doing wrong.

[ayman_salem]

The List of Values of the object that you use in the Prompt must be updated before use.

you can do it in IDT under "Parameters and Lists of Values"--> Options --> "Force users to filter values before use"

...

Second, the row-level restriction only applies to the query (added in where clause) only if an object in your query accesses the same restricted table.

[former_member185138]

thanks ayman.salem for response.

I am using list of value with custom SQL and the "Force users to filter values before use" is greyed out.

query is :

select DB_Name from db

I am refereing below blog for our requirement for dynamic datasource:

http://trustedbi.com/2012/12/19/dynamic-data-connection