SQL Error: ORA-01720: grant option does not exist for ‘OWNER_SCHEMA”.MY_TABLE’
01720. 00000 – “grant option does not exist for ‘%s.%s'”
*Cause: A grant was being performed on a view and the grant option was
not present for an underlying object.
*Action: Obtain the grant option on all underlying objects of the view.
This error occurs when a user want to GRANT a privilege on an object where it is not the owner (directly or through a view).
To be able to grant a privilege to a user on an object where you are not the owner, the owner must grant you the privileges with the “with grant option” statement.
GRANT SELECT ON “OWNER_SCHEMA”.”MY_TABLE” TO “NOT_OWNER_USER” WITH GRANT OPTION;
then the user “NOT_OWNER_USER” can grant the SELECT privilege to an other user.
GRANT SELECT ON “OWNER_SCHEMA”.”MY_TABLE” TO “ANOTHER_NOT_OWNER_USER” WITH GRANT OPTION;