Hive权限管理

角色的添加、删除、查看、设置：

 

CREATE ROLE role_name;  -- 创建角色

DROP ROLE role_name;  -- 删除角色

SET ROLE (role_name|ALL|NONE);  -- 设置角色

SHOW CURRENT ROLES;  -- 查看当前具有的角色

SHOW ROLES;  -- 查看所有存在的角色

 

将角色授予某个用户、角色：

GRANT role_name [, role_name] ...

TO principal_specification [, principal_specification] ...

[ WITH ADMIN OPTION ];

 

principal_specification

  : USER user

  | ROLE role

 

将角色授予某个用户、角色：

GRANT role_name [, role_name] ...

TO principal_specification [, principal_specification] ...

[ WITH ADMIN OPTION ];

 

principal_specification

  : USER user

  | ROLE role

 

Hive权限管理

权限：

SELECT privilege – gives read access to an object.

INSERT privilege – gives ability to add data to an object (table).

UPDATE privilege – gives ability to run update queries on an object (table).

DELETE privilege – gives ability to delete data in an object (table).

ALL PRIVILEGES – gives all privileges (gets translated into all the above privileges).