Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01720: grant option does not exist

user545194Mar 3 2023

Scenario:

User A is missing the grant option for an object owned by user B. User B grants the privilege with grant option to user A.

User A creates a role and adds the privilege to that role, i.e. “GRANT SELECT ON user_b.table_b TO role”;

Grant succeeds, but error ORA-01720 still exists. Logged in an error table.

No idea what the problem could be.

This post has been answered by Solomon Yakobson on Mar 6 2023
Jump to Answer
Comments
Post Details
Added on Mar 3 2023
13 comments
28,043 views