Teradata - Add User to a Role

visibility 160 access_time 2 years ago languageEnglish

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.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.33
More from Kontext
Convert TimeStamp to Date in Teradata
visibility 16,351
thumb_up 0
access_time 2 years ago
Teradata: Rights Held by Database
visibility 48
thumb_up 0
access_time 2 years ago
Teradata RPAD - Right Padding
visibility 587
thumb_up 0
access_time 2 years ago