How provide grant to a table in sentry

Asked Apr 28 '17 at 20:08

Active Apr 28 '17 at 21:34

Viewed 365 times

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.

edited Apr 28 '17 at 21:34

franklinsijo

17,784
4
45
63

asked Apr 28 '17 at 20:08

Rockshell

Why do you expect the privilege granted to **hr** role to show under **emp** role??? Just type `SHOW GRANT ROLE hr_role`. – Samson Scharfrichter Apr 30 '17 at 21:19
@SamsonScharfrichter you put me back in track. Thank you! – Rockshell May 01 '17 at 13:50

How provide grant to a table in sentry

0 Answers0