16.20 - Teradata Secure Zones - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Data Control Language

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1149-162K

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.

To ... the user must have the ...
create a zone and create a zone root CREATE ZONE privilege
drop a zone DROP ZONE privilege
add or drop a zone root ALTER ZONE privilege
assign a primary DBA to a zone CREATE USER AS DBA or MODIFY USER AS DBA
grant zone access to zone guests GRANT ZONE
revoke the zone access of zone guests REVOKE ZONE