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