Object type “nested” implicit grants
A colleague got an “ORA-01720: grant option does not exist” error and couldn’t understand why. So together we researched a bit and learned some things about how object type grants across schemas works – including a small surprise that was the reason for our puzzlement….