How to write script in Ranger

[#1]

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 !!

[#2 · Accepted solution]

@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

[#3]

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+P...

[#4]

@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).