Skip to Content
0
Former Member
Nov 27, 2008 at 03:31 AM

Universe-Manage Security-How to restrict table based on another table

40 Views

Assume the scenario where I have an Employee table in universe. Now I have another table in the universe called Employee_Master.

Is it possible to restrict rows of Employee table based on Employee_Master ?

The problem is that if I include the Employee_Master table in the rule but the use selects only Employee table for his report, this rule will give a SQL error as Employee_Master is not included in the FROM of SQL query.

Any suggestions ?

Thanks

Binayak