Delegated GRANT and REVOKE allows admin users to delegate the GRANT privilege to other users using WITH GRANT OPTION.

Configuration

No special configuration increased.

Delegating GRANT/REVOKE Privileges

Hive or Impala users can grant privileges by the SQL statement GRANT ... WITH GRANT OPTION :

GRANT
    priv_type [, priv_type ] ...
    ON table_or_view_name
    TO principal_specification [, principal_specification] ...
    [WITH GRANT OPTION];

 

  • No labels