Configuring System Objects - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™
The requirements for System objects in the directory varies, depending on the configuration of Teradata Vantage systems:
  • If the directory serves a single Teradata Vantage system, create a single System object.
  • If the directory serves multiple Vantage systems:
    • If all systems maintain the same set of users, profiles, roles and IP filters, and they are mapped to directory users in the same manner, you only need a single System object for all systems.
    • If the users, profiles, roles, and IP filters diverge among database systems, then you should create a separate System object for each Vantage system.
    • If directory users for multiple Vantage systems log on through Unity, Teradata recommends that the LdapSystemFQDN property on all Vantage systems and connected Unity servers use the same authorization structure. If all Unity managed systems authenticate to the same directory, they should point to the same tdatSystem object. If they authenticate to different directories, the mappings to child objects for the tdatSystem object in each directory should be the same in all directories. See Teradata® Unity™ Installation, Configuration, and Upgrade Guide for Customers, B035-2523 and Teradata® Unity™ User Guide, B035-2520.