Oracle Error :: ORA-01720
grant option does not exist for 'string.string'
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.
Comments (Add Comment)
08/11/2005 12:10:16 by Phil
Would be helpful if I knew what a grant option was...
07/02/2010 16:26:33 by Shlooks
USER_A : SOME_TABLE
USER_B : SOME VIEW AS SELECT * FROM USER_A.SOME_TABLE
USER_C : Should select from USER_B.SOME_VIEW
Because USER_C needs to read from USER_A, the "middle" user, USER_B must granted with "grant option" as:
GRANT SELECT ON USER_A.SOME_TABLE to USER_B WITH GRANT OPTION;