Grant User Membership in a Role | Teradata VantageCloud Lake - Grant User Membership in a Role - Teradata VantageCloud Lake

Lake - Database Reference

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

After creating database users, grant those users membership in one or more roles to provide the required database access privileges.

  1. From the client program of your choice, log on to Vantage as user DBADMIN.
    Related: CREATE ROLE
  2. Run a GRANT request similar to the following:
    Grant "Role_1" To "GenUser1";

    Related: GRANT (SQL Form)

  3. Repeat this procedure for each role to which a user requires membership.