17.10 - Examples: Inserting Role Objects into a Roles Container - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Use the following syntax to create role objects that represent Teradata Vantage external roles and insert them into the appropriate roles container.

dn: cn=adminrole,ou=roles,ou=system1,ou=tdat,dc=domain,dc=com
objectClass: top
objectClass: groupOfNames
cn: adminrole
member:  group_dn 
objectClass: top
objectClass: groupOfNames
cn: userrole
member:  group_dn 

The cn for each role object must match the name of a Vantage external role.

At least one member attribute and associated value is required when the role object is created.

group_dn is either:
  • The dn of the roles container, if no individual role members are known
  • The dn of a directory group that you want to map to the role, for example:
    member: cn=administrators,ou=groups,dc=domain,dc=com