Hive赋予用户查询某表管理员权限 hive查看表所属用户

1、以表为单位，查询每个表具有什么权限

select s.*,(select tbl_name from tbls where tbl_id=s.tbl_id) tbl_name,(select name from dbs where db_id=(select db_id from tbls where tbl_id=s.tbl_id)) db_name from (select principal_name,principal_type,tbl_id,string_agg(tbl_priv,',') from tbl_privs group by principal_name,principal_type,tbl_id) s;

2、以账号为单位，查询每隔账号有哪些表的权限

select PRINCIPAL_NAME,PRINCIPAL_TYPE,substr(string_agg(db_name||'.'||tbl_name,','),1,100)m from (select s.*,(select tbl_name from tbls where tbl_id=s.tbl_id) tbl_name,(select name from dbs where db_id=(select db_id from tbls where tbl_id=s.tbl_id)) db_name from (select principal_name,principal_type,tbl_id from tbl_privs group by principal_name,principal_type,tbl_id) s)tt group by PRINCIPAL_NAME,PRINCIPAL_TYPE ；