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 '