17.05 - Examples of Using Revoke (SQL Form) - 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 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;