question How to write script in Ranger in Archives of Support Questions (Read Only)

How to write script in Ranger

bigdataam09 — Thu, 29 Sep 2016 04:06:25 GMT

In hive schema, I have 300 tables and my requirement is provide access to 100 tables to a set of users. Is there anyway In Ranger to add tables in bulk while creating a policy.

In the Ranger Create Policy UI, I can add table one by one.

Is there a way to write script to add tables to Ranger policy.

Thanks for your help !!

Re: How to write script in Ranger

sshimpi — Thu, 29 Sep 2016 04:08:39 GMT

@Amit Kumar Agarwal

Using ranger rest api you can achieve this. Pls refer - https://cwiki.apache.org/confluence/display/RANGER/REST+APIs+for+Policy+Management

Re: How to write script in Ranger

mneethiraj — Thu, 29 Sep 2016 04:38:00 GMT

@Amit Kumar Agarwal If wildcards can be used to specify the tables (for example: "test*", "finance*"), it can make working with policies a little easier i.e. simpler than looking through a long list of tables. Ranger supports 2 wildcard characters "*" (0 or more characters) and "?" (single character).

Re: How to write script in Ranger

mneethiraj — Thu, 29 Sep 2016 04:39:19 GMT

For HDP-2.3 or later, please use the REST API documented here: https://cwiki.apache.org/confluence/display/RANGER/REST+APIs+for+Service+Definition%2C+Service+and+Policy+Management