hive表级权限控制_FAQ-FusionInsight-Hive权限控制

最新推荐文章于 2023-11-24 17:27:40 发布

伤的太深

最新推荐文章于 2023-11-24 17:27:40 发布

阅读量162

点赞数

文章标签： hive表级权限控制

本文链接：https://blog.csdn.net/weixin_30986517/article/details/111896421

版权

create database a;use a;create table table_a (id int);set role admin;grant select on database a to user sasuser WITH GRANT OPTION;show grant on table table_a;+-----------+----------+------------+---------+-----------------+-----------------+------------+---------------+----------------+------------+--+| database | table | partition | column | principal_name | principal_type | privilege | grant_option | grant_time | grantor |+-----------+----------+------------+---------+-----------------+-----------------+------------+---------------+----------------+------------+--+| a | table_a | | | etlhadoop | USER | DELETE | true | 1504677540000 | etlhadoop || a | table_a | | | etlhadoop | USER | INSERT | true | 1504677540000 | etlhadoop || a | table_a | | | etlhadoop | USER | SELECT | true | 1504677540000 | etlhadoop || a | table_a | | | etlhadoop | USER | UPDATE | true | 1504677540000 | etlhadoop || a | table_a | | | sasuser | USER | SELECT | true | 1504677737000 | etlhadoop |