SQL REVOKE Command:The REVOKE command removes user access rights or privileges to the database objects.
Syntax:REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
Example:REVOKE SELECT ON employee FROM user1
This command will REVOKE a SELECT privilege on employee table from user1.