Hi, There is a User who has two roles. The access to these roles are maintained in a table which has all the dimensions as columns. For example if a User is a Geography Head, Geo_Id column will have that particular geography's code against the user. In our scenario the user is both Geography Head and also Vertical Head, and Geography code and Vertical code are populated against the user in the table. When we do Row level security, the data is fetched as a combination of Geography and Vertical, but the user should be able to see the whole data related to the Geo or the whole data related to the vertical(based on the user's preference of looking at the report). If the user wants to view the data as only the Geography head or the vertical head how can we achieve this?
... View more