ORA-01720 – grant option does not exist for ‘AnObject’

Error report:
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;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."