SQL GRANT and REVOKE 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.
