Row Level Permission

Dremio University
1

I am trying to implement row level permissions. Introduction of where clause empties my dataset and no data is returned.

SELECT * FROM dcf_vw_NRM_Internal_Sales
–where clause that empties the dataset below
where query_user() in (‘Sandeep.Kotian@someemail.com’) and category in (‘Spirit’)

2

Hi @akiladevi.b

Is this failing due to the query_user or category filter?

https://docs.dremio.com/security/row-level-permissions.html#creating-a-virtual-dataset-with-row-level-permissions

Thanks
@balaji.ramaswamy