Oracle database-ora-01720-grant option does not exist for ' anobject '

Description

When a owner-not_owner_user that is not my_table This table tries to grant my_table permission, an error occurs:

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 is being performed on a view and the grant Optio n is not           present-a underlying object.*action:   Obtain the grant option on all underlying objects of the view.

Caused by

Not_owner_user is not the owner of My_table, and does not have permission to grant it the owner (owner does not grant permission to not_owner_user down, but may give its select or Permissions for update).

Solution

1 GRANT SELECT  on  to  with GRANT OPTION;

References

• Oracle database-ora-01720-grant option does not exist for ' anobject '
• Grant privilges error to the schema

Oracle database-ora-01720-grant option does not exist for ' anobject '