SQL Grant/revoke privileges


Example

GRANT SELECT, UPDATE
ON Employees
TO User1, User2;

Grant User1 and User2 permission to perform SELECT and UPDATE operations on table Employees.


REVOKE SELECT, UPDATE
ON Employees
FROM User1, User2;

Revoke from User1 and User2 the permission to perform SELECT and UPDATE operations on table Employees.