Need Help on giving permissions to user:

[#1]

--> Created user “XXX” from Hue, when user XXX logged in to hue he is not able to see any databases, he could able to see
only default database.
--> Created group bi_group from hue, there is no unix group- group_bi
--> Assigned required application to bi_group from hue.
--> Assigned user “XXXX” to group “bi_group”, user XXX could able to see the assigned applications when he logged in.
--> Connnected to beeline.
beeline --> Created database -> create database bi_database;
beeline --> use bi_database;
beeline --> Created role -> create role bi_role;
beeline --> grant role bi_role to group bi_group
beeline --> grant all on database bi_database to role bi_roles;

after doing this stuff user not able to see only default database from hue, from hive he is not able to create table under bi_database. But he could able to do show tables; show databases;

Please suggest, did i am missing any steps?

[#2 · Accepted solution]

Did you make sure that the user XXX really belong to the UNIX bi_group?

e.g. example at the end of
http://gethue.com/apache-sentry-made-easy-with-the-new-hue-security-app/

Romain