Examples of Using Revoke (SQL Form) - Advanced SQL Engine - Teradata Database

SQL Data Control Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
lmb1556233084626.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1149
lifecycle
previous
Product Category
Teradata® Vantage™ NewSQLEngine

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;