WITH GRANT OPTION and PUBLIC Keywords

Give a user authority to pass along the privileges

SQL> GRANT select, insert
  2  ON dept
  3  TO scott
  4  WITH GRANT OPTION;
Grant succeeded.


Allow all users on the system to query data from Alice’s DEPT table.

SQL> GRANT select
  2  ON alice.dept
  3  TO PUBLIC;
Grant succeeded.