Examples of Using Revoke (SQL Form) - Teradata Vantage - Analytics Database

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 may have had on personnel; therefore, UserA may 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;