Adding users to Hadoop SQL Ranger policies
You must grant the Hadoop SQL Ranger permissions to enable your users to access specific tables and secure your data from unauthorized access.
- Sign in to Cloudera Data Warehouse.
Click the More… option on your Database Catalog and
click Open Ranger.
- On the Ranger Service Manager page, click Hadoop SQL.
Select the all - url policy.
The Edit Policy page is displayed.
Under the Add Conditions section, add the users under
the Select User column and add permissions such as
Create, Alter, Drop, Select, and so on from the
- Scroll to the bottom of the page and click Save.