Teradata - Add User to a Role

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.