...
| Code Block | ||
|---|---|---|
| ||
SET ROLE (role_name|ALL|NONE); |
If a role_name is specified, then that role becomes the only role in current roles.
Setting role_name to ALL refreshes the list of current roles (in case new roles were granted to the user) and sets them to the default list of roles.
Setting role_name to NONE will remove all current roles from the current user. (It's introduced in HIVE-11780 and will be included in the upcoming versions 1.3.0 and 1.2.2)
If a role the user does not belong to is specified as the role_name, it will result in an error.
...