ALTER ZONE Syntax Elements - Teradata Vantage - Analytics Database
SQL Data Definition Language Syntax and Examples
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-22
- dita:mapPath
- jco1628111346878.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- mdr1472255012272
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- zone_name
- Name of an existing secure zone.
- ADD ROOT
- Add a root database or user to a secure zone.
- Only the secure zone creator can ADD a root.
- The root cannot be a part of another zone.
- Root should be an existing user or database. You should create the user or database before you specify the user or database as root.
- The user or database that you specify cannot be a guest, creator, or member of another zone and cannot contain objects, descendants, roles, profiles, or constraints.
- Only the zone creator, owner and creator of root can have privileges on the root. Other users cannot have privileges on the root. Root cannot have any privileges on other users.
- Root cannot be a proxy user.
- Root should not be granted with any roles or constraints.
- The user should not be logged in while adding him as a zone root.
- Root cannot have a database as default database.
- The user or database that you specify cannot have any Access logging or Query logging rules enabled on them or created by them.
- DROP ROOT
- De-link the root database or user from the secure zone.
- Only the zone creator can DROP a root.
- The root cannot contain any objects, descendants, roles, constraints, or profiles.
- The root database or user cannot have any Access logging or Query logging rules enabled on them or created by them.
- All the zone guests must be removed from the zone.
- The root user should not be logged in while dropping zone root.