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.