I am facing an issue when assign permission on view created on unity catalog. The problem is I had create a user defined function (UDFs) in order to encrypt sensitive column, I create a view which call the functions and source table within the catalog. I need to assign select permission to both table & view in order for users to select data, which I don't want users to be able to directly access the table.
Is there any other practice supporting this used case would be very helpful. Thank you
