08-28-2014 03:16 PM
To set up policy for sentry service, I saw that there is an example of set select permission for a database on cloudera doc:
GRANT SELECT ON DATABASE jranalyst1 TO ROLE analyst_role;
How can I set the select permission on table A in Database B to Role C ? Thanks!
08-28-2014 03:25 PM - edited 08-28-2014 03:26 PM
You can switch to the database and grant privileges on the table.
GRANT SELECT ON TABLE a TO ROLE c;
Hive currently doesnt support fully qualified table names (db1.tb1) in grant/revoke sql, and that is the reason you will need to switch to the database first to be able to grant privileges on a table.