An user is assigned multiple groups but unable to query a data table

CL1
New Contributor

Hi all, 

I have a user who is enrolled in multiple groups within databricks but she is only able to query one of the query tables based on the original group assigned. 

For example:

Group 1 will only be able to view data where [group] (column) = 'group1' (value)
Group 2 will only be able to view data where [group] (column)  = 'group2' (value)

I have added this user in both group 1 and 2, so she should be able to query for both groups' data i.e. [group]= 'group1' or 'group2'. But she is only able to view 'group1' only.

Can someone advise? Thank you