17.10 - Adding a Primary DBA to a Zone - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

Only the zone creator can add the primary DBA user to a zone. This user cannot be a part of any other zone.

If the zone creator creates the root of the zone on a user, that user automatically becomes the zone’s primary DBA. This user must be an existing user who has no preexisting objects, descendants, roles, profiles, or grants.

If the zone creator creates the root of the zone on a database, the zone creator must use the following syntax to create the primary DBA user:

CREATE USER DBA_user_name FROM database_name [...] ;

The database_name is the name of the database that the zone was created on.

You can add other valid syntax after the AS clause. For information about the CREATE USER syntax, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.