Teradata Secure Zones | DB Administration Privileges | Teradata Vantage - Teradata Secure Zones - Database Engine 20 - Teradata Vantage

SQL Data Control Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-07-02
dita:mapPath
knb1747160619932.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢

The DBC user or a user who already has the CREATE ZONE, DROP ZONE, and WITH GRANT OPTION privileges must explicitly grant these privileges to a zone creator.

Goal Privileges User Needs
Create zone and zone root CREATE ZONE privilege
Drop zone DROP ZONE privilege
Add or drop zone root ALTER ZONE privilege
Assign primary DBA to zone CREATE USER AS DBA or MODIFY USER AS DBA
Grant zone access to zone guests GRANT ZONE
Revoke zone access of zone guests REVOKE ZONE