Syntax:
To grant a privilege:
Grant <privilege name> on <tablename> to <username>;
To revoke a privilege
Revoke <privilege name> on <tablename> from <username>;
Example:
To grant a select privilege to a user B from A, use
GRANT SELECT ON EMP TO B; DISPLAYS,
Grant succeeded. While revoking,
REVOKE select on emp from b; Revoke succeeded.