Teradata - Add User to a Role

visibility 78 comment 0 access_time 10m 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

Tags
More from Kontext