Granting permissions to run SQL queries

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

  1. Log in to the Data Warehouse service as DWAdmin.
  2. Go to the Database Catalog tab, locate your Database Catalog, and click > Open Ranger.
    The Ranger application opens in a new browser tab.
  3. Click Hadoop SQL on the Service Manager page.
  4. Click Add New Policy.
  5. Specify the databases, tables, and columns on which you want to grant permissions to the users.
  6. Under the Allow Conditions section, specify users or groups to whom you want to grant permissions.
    you can specify {USER} to grant permissions to all users.
  7. Click Add Permissions and select permissions such as Create, Alter, Drop, Select, and so on.
    Image showing how to add a new Hadoop SQL policy on the Ranger UI .
  8. Click Add to save the settings.