16.20 - Examples of Using Revoke (SQL Form) - 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 the INSERT Privilege

This request revokes the INSERT privilege from UserA on the employee table:

     REVOKE INSERT
     ON personnel.employee
     FROM UserA;

Revoking Access That Requires Database Privileges

The following request revokes from UserA any access to any object that requires database, but not table, privileges in the personnel database:

     REVOKE ALL PRIVILEGES
     ON personnel
     FROM UserA;

Using ALL BUT When Revoking Privileges

The following request leaves UserA with table privileges and at least the SELECT privilege on the Department table:

     REVOKE ALL BUT SELECT
     ON Personnel.Department
     FROM UserA;

The statement does not revoke database-level privileges or table-level privileges that UserA might have had on personnel; therefore, UserA might still have the ability to perform other requests such as an INSERT into personnel.department.

The following request leaves UserA with the SELECT privilege and all table-level privileges on every object in the personnel database:

     REVOKE ALL BUT SELECT
     ON personnel
     FROM UserA;