Teradata - Add User to a Role

event 2021-01-19 visibility 813 comment 0 insights
more_vert
insights Stats
Raymond Raymond Code Snippets & Tips

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise. 

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. 

More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts