REVOKE (SQL Form) Examples - Teradata VantageCloud Lake

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;