Support Questions

Find answers, ask questions, and share your expertise

Access to view but not table or data

New Contributor

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?

1 REPLY 1

Champion

@nullbyte

 

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.