16.20 - Revoking Privileges From Roles - 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

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;