02-15-2018 02:08 PM
I have an external Impala table defined. I also have a view that selects a subset of columns from the table. Can i grant access to the view only but not the table or underlying data?
02-16-2018 08:26 AM
Yes it is possible with Apache Sentry. Pls find below a very high level steps
pre-request: Make sure you have sentry
You can create a group & assign the required users to the group.
Create a role & GRANT <read only> ON SERVER <myserver> TO ROLE <rolename> WITH GRANT OPTION;
grant role to the group.