Revoking the CTCONTROL Privilege - 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ā„¢

If you specify the GRANT OPTION FOR option with a REVOKE request on the CTCONTROL privilege, the specification removes only the ability of the recipient to grant the privilege to others. The CTCONTROL privilege itself is not revoked when you specify GRANT OPTION FOR. Instead, you must submit a REVOKE request on the user that does not specify GRANT OPTION FOR.

The following example revokes from user kate the privilege to grant the CONNECT THROUGH privilege to any Vantage user:

REVOKE CTCONTROL FROM kate;

This request revokes the CTCONTROL privilege from kate, not only her ability to grant CTCONTROL to other users, which as in the following request:

REVOKE GRANT OPTION FOR CTCONTROL FROM kate;