USING REVOKE

This is used to revoke the privileges from the users to which you granted the privileges.

Syntax:

     Revoke <privileges> on <object_name> from <user_name>;

Ex:

     SQL> revoke select on student form DP;         -- you can revoke individual privilege

     SQL> revoke select, insert on student from DP;   -- you can revoke set of privileges

      SQL> revoke all on student from DP;  -- you can revoke all privileges