17.05 - Revoking Privileges From Roles - Teradata Database

Teradata Vantageā„¢ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

Revoking a privilege from a role does not necessarily revoke the privilege from all of its role members. A member who has been 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;