Hue权限管理实操

1. 收回某个user的role

revoke role role_name from user user_name;

2.收回某个role的某张表的权限

revoke select on table table_name from role role_name;

3.查看user下的role

show role grant user user_name;

4，创建视图，创建role，赋权给user（）

#删除视图
drop view view_name;

#创建视图

create view view_name as select * from table_name where pt='2019-05-26';

create view view_name  as select * from table_name where pt=date_add(from_unixtime(unix_timestamp(),'yyyy-MM-dd'), -1);

grant select on table_name to role view_name ;

grant SELECT on table table_name to role view_name ;

#创建role
sudo useradd user_name;

create role role_name;

grant role role_nameto user user_name;


#重启hue
cd  /home/admin/qing_han/hue-3.9.0-cdh5.8.5/build/env
bin/hue useradmin_sync_with_unix