CODEWITHSUNDEEP
hadoophive
bheussler
bheussler

Reputation: 1426

Is it possible to get Role information via Hive QL?

I understand the concept of a role that Hive uses for security. Is it possible to find this information via Hive QL using a statement like DISPLAY ROLES?

Bonus: Is it possible to get Hadoop user information via Hive QL?

Upvotes: 3

Views: 16134

Answers (2)

whyceewhite
whyceewhite

Reputation: 6425

To display all roles in Cloudera Hive, use the following command:

SHOW ROLES;

Refer to Cloudera's Sentry Service documentation for more SHOW statements.

Upvotes: 2

dimamah
dimamah

Reputation: 2903

to view roles :
SHOW ROLE GRANT principal_specification

to view privilages :
SHOW GRANT principal_specification
[ON object_type priv_level [(column_list)]]

where :
principal_specification
: USER user
| GROUP group
| ROLE role

For more details look here

Upvotes: 6

Related Questions