How to fix the Oracle error ORA-01720: grant option does not exist for ‘string.string’?

In this post, you’ll learn more about the Oracle ErrorORA-01720: grant option does not exist for ‘string.string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01720: grant option does not exist for ‘string.string’

Reason for the Error ORA-01720: grant option does not exist for ‘string.string’

A grant was being performed on a view or a view was being replaced and the grant option was not present for an underlying object.

How to fix the Error ORA-01720: grant option does not exist for ‘string.string’ ?

You can fix this error in Oracle by following the below steps

Obtain the grant option on all underlying objects of the view or revoke existing grants on the view.