REVOKE : To revoke privileges granted to other users Privileges granted to others through the WITH GRANT OPTION clause are also revoked.Syntax] REVOKE {privilege [, privilege ...] | ALL } ON object FROM {user [,user....] role | PUBLIC | [CASCADE CONSTRAINTS]; CASCADE is required to remove any referential integrity constraints made to the CONSTRAINTS object by means of the REFERENCES privileges. ..