title: How to grant Ranger permissions for a new user on a Secure Cluster author: Weixia Xu type: post date: 2020-05-19T00:00:00+00:00 url: /blog/how-to-grant-ranger-permissions-for-a-new-user/ sf_thumbnail_type:
Hello, Hue administrators,
The Apache Ranger™is a framework to enable, monitor and manage comprehensive data security across the Hadoop platform.
Hue integrates with Ranger since Hue4.6, on any secure cluster with Ranger installed, the user has to have proper permissions to operate on the data to avoid following permission warning.
Here let's show the detailed steps to grant permission for any new user through CM UI.
open a terminal and ssh to your ranger usersync host which you noted down at Step 1;
ssh root@weixia-1.domain.site useradd weixia passwd weixia
On Ranger admin webui page: https://weixia-1.domain.site:6182/index.html#!/policymanager/resource, click on "Edit" button besides the "Hadoop SQL":
a. if you want to give new user permission on all databases, add your user on the existing policy: "all-database, table, column"

b. if you want to give new user only to specific database say 'testdb', you can create new policy as following,
choose permission as you desired:

Navigate to Hue WebUI, now your new user should be able to run any query on any entities as granted in the policy.

You can do the same for group permission as well.
Any feedback or questions? Feel free to comment here or on the Forum or @gethue and quick start SQL querying!
Weixia Xu from the Hue Team