Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Sentry grant on a table

avatar
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

avatar
Contributor

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

View solution in original post

1 REPLY 1

avatar
Contributor

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