WITH ADMIN OPTION

How to Resolve ORA-01939: only the ADMIN OPTION can be specified

by Ed Chen
April 5, 2023April 4, 2023

ORA-01939 Tried to grant a system privilege to an user, but it failed with ORA-01939. SQL> grant select any table to sh with grant option;… Read More »

How to Resolve ORA-00993: missing GRANT keyword

by Ed Chen
April 4, 2023April 4, 2023

ORA-00993 Tried to grant an object privilege to an user, but it failed with ORA-00993. SQL> grant select on hr.employees to sh with admin option;… Read More »

How to Resolve ORA-01720: grant option does not exist

by Ed Chen
December 3, 2019March 3, 2023
28 Comments

ORA-01720 Got error ORA-01720 when we tried to grant an object privilege to another user. ORA-01720 means that the grantor doesn't have the right privilege… Read More »

JavaScript is not enabled. Please enable it and reload the page.