Permission on Unity catalog
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2023 04:13 AM
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