THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| No Format |
|---|
GRANT ROLE role_name [, role_name] ... TO principal_specification [, principal_specification] ... REVOKE ROLE role_name [, role_name] ... FROM principal_specification [, principal_specification] ... principal_specification: : USER user | GROUP group | ROLE role |
...
| No Format |
|---|
SHOW ROLE GRANT principal_specification principal_specification: USER user | GROUP group | ROLE role |
| Info | ||
|---|---|---|
| ||
The output of SHOW ROLE GRANT is in tabular format starting with Hive 0.13.0 (HIVE-6204). |
...
| No Format |
|---|
GRANT
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
[ON object_type]
TO principal_specification [, principal_specification] ...
[WITH GRANT OPTION]
REVOKE
priv_type [(column_list)]
[, priv_type [(column_list)]] ...
[ON object_type priv_level]
FROM principal_specification [, principal_specification] ...
REVOKE ALL PRIVILEGES, GRANT OPTION
FROM user [, user] ...
objectpriv_type:
ALL TABLE
| ALTER | DATABASE
priv_level:
db_nameUPDATE | CREATE | DROP
| tbl_name
|
Viewing Granted Privileges
INDEX | LOCK | SELECT | SHOW_DATABASE
object_type:
TABLE
| DATABASE
priv_level:
db_name
| tbl_name
principal_specification:
USER user
| GROUP group
| ROLE role |
Viewing Granted Privileges
| No Format |
|---|
SHOW GRANT principal_specification
[ON object_type priv_level [(column_list)]]
principal_specification:
USER user
| GROUP group
| ROLE role
object_type:
TABLE
| DATABASE
priv_level:
db_name
| tbl_name |
| No Format |
SHOW GRANT principal_specification
[ON object_type priv_level [(column_list)]]
|
| Info | ||
|---|---|---|
| ||
The output of SHOW GRANT is in tabular format starting with Hive 0.13.0 (HIVE-6204). |
...