Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.