New Contributor
Posts: 3
Registered: ‎02-15-2018

Access to view but not table or data

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?

Posts: 519
Topics: 14
Kudos: 91
Solutions: 45
Registered: ‎09-02-2016

Re: Access to view but not table or data



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.