SQL> CREATE USER JOHN_DOE IDENTIFIED BY User_test1111; USER created. SQL> GRANT SELECT ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> GRANT INSERT ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> GRANT UPDATE ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> GRANT DELETE ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> GRANT ALL PRIVILEGES ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> REVOKE SELECT ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded. SQL> REVOKE INSERT ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded. SQL> REVOKE UPDATE ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded. SQL> REVOKE DELETE ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded. SQL> REVOKE ALL PRIVILEGES ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded. SQL> GRANT SELECT,UPDATE ON EMPLOYEES TO JOHN_DOE; Grant succeeded. SQL> REVOKE SELECT,UPDATE ON EMPLOYEES FROM JOHN_DOE; Revoke succeeded.