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