Error 5616 : The user is not authorized to grant or revoke role
Teradata user is not authorized to grant or revoke role.
Ran below command by user login_user
grant my_role_name to my_user;
Executed as Single statement. Failed [5616 : HY000] The user is not authorized to grant or revoke role ‘my_role_name’.
Elapsed time = 00:00:00.011
STATEMENT 1: GRANT failed.
Only the user DBC, or a user granted this role WITH ADMIN OPTION, or a user with an
applicable role (current role or a role nested within it) that is granted a role WITH
ADMIN OPTION has the right to GRANT/REVOKE the role to/from another user or role.
Re-run the same command with different user who have required access or run below
grnat to your current user (which which you tried to run grant) below access (Run as
dbc or other poer user) :-
grant my_role_name to login_user with admin option;
Now, login back as login_user and re-run failed grant sql.