Revoking Privileges from Roles - 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ā„¢

Revoking a privilege from a role does not necessarily revoke the privilege from all its role members. A member who was granted the same privilege on an individual basis or through another role retains that privilege until it is explicitly revoked.

The following request revokes the privilege from the finance role to change the personnel database:

     REVOKE UPDATE, DELETE, INSERT
     ON personnel
     FROM finance;