Oracle Database - ORA-01720 - grant option does not exist for 'AnObject'

Card Puncher Data Processing

About

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.

Example

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;

Otherwise, you will receive this error for instance, for a view:

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.





Discover More
Card Puncher Data Processing
Oracle Database - Error (Ora-XXXXX)

Cause See the Solution section of this document Solution If you receive the message when testing database links: ORA-12514: TNS: listener could not resolve SERVICE_NAME given in connect descriptor either:...



Share this page:
Follow us:
Task Runner