Teradata - Add User to a Role

visibility 204 access_time 2 years ago languageEnglish
more_vert

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. 

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts