DROP ROLE Statement (Impala 2.0 or higher only)
The DROP ROLE
statement removes a role from the metastore database. Once dropped, the role
is revoked for all users to whom it was previously assigned, and all privileges granted to that role are
revoked. Queries that are already executing are not affected. Impala verifies the role information
approximately every 60 seconds, so the effects of DROP ROLE
might not take effect for new
Impala queries for a brief period.
Syntax:
DROP ROLE role_name
Required privileges:
Only administrative users for Ranger can use this statement.
Compatibility:
Impala makes use of any roles and privileges specified by the GRANT
and
REVOKE
statements in Hive, and Hive makes use of any roles and privileges specified by the
GRANT
and REVOKE
statements in Impala. The Impala GRANT
and REVOKE
statements for privileges do not require the ROLE
keyword to be
repeated before each role name, unlike the equivalent Hive statements.
Related information:
Impala Authorization, GRANT Statement (Impala 2.0 or higher only) REVOKE Statement (Impala 2.0 or higher only), CREATE ROLE Statement (Impala 2.0 or higher only), SHOW Statement
Cancellation: Cannot be cancelled.
HDFS permissions: This statement does not touch any HDFS files or directories, therefore no HDFS permissions are required.