Cloudera Docs

Granting permissions to run SQL queries

You must grant Hadoop SQL Ranger permissions to your users so they can query tables.

  1. In Cloudera Data Warehouse, click in your Database Catalog and click Open Ranger.
  2. In Ranger Service Manager, click Hadoop SQL.
  3. Select the all - url policy.
  4. In Allow Conditions, click Edit Policy, select users, and add permissions such as Create, Alter, Drop, and Select.
  5. Save the settings.