Add user to a role
The following code snippet add userA to a role named TestRole:
grant TestRole to userA;
Add user to a role with admin option
You can also grant a role to a user with admin option so that the user can drop role, grant and revoke roles from user.
grant TestRole to userA with admin option;
The above code snippet adds user userA to role TestRole with admin option.