Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sentry grant on a table

Solved Go to solution
Highlighted

Sentry grant on a table

Contributor

I have a employee_database and under employee_database I have tables salary_table and bonus_table. Right now emp_role has full access on employee_database. I would also like to give select access to hr_role on bonus_table. How can I achieve this in sentry?

 

SHOW GRANT ROLE emp_role;

1 hdfs://localns/emp emp_role ROLE * false
2 employee_database emp_role ROLE * false

GRANT SELECT ON TABLE emp_database.bonus_table to role hr_role;

SHOW GRANT ROLE emp_role;

1 hdfs://localns/emp emp_role ROLE * false
2 employee_database emp_role ROLE * false

 

I don't get error when I run the above grant but i don't see the grant in the list.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sentry grant on a table

Contributor

I had to check grant in hr_role instead of emp_role. This is the solution for this question.

1 REPLY 1

Re: Sentry grant on a table

Contributor

I had to check grant in hr_role instead of emp_role. This is the solution for this question.

Don't have an account?
Coming from Hortonworks? Activate your account here