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.

  1. Sign in to Cloudera Data Warehouse.
  2. Click the > Open Ranger option on your Database Catalog.

    This screenshot shows how to open Ranger from the Database Catalog more... menu on the CDW web interface.
  3. On the Ranger Service Manager page, click Hadoop SQL.
  4. Select the all - url policy.
    The Edit Policy page is displayed.
  5. 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 Permissions column.

  6. Scroll to the bottom of the page and click Save.