Re: ORA-01720: grant option does not exist for 'S.P'
Date: Wed, 11 Nov 2009 20:55:24 +0100
Just to make sure, do you have Datbase Vault on this system?
> I have a schema S which holds a view V and a procedure P. I have
> also defined a role R
> Procedure P is used in the view definition V
> when trying to execute
> GRANT SELECT ON S.V to R
> I encounter this error
> ORA-01720: grant option does not exist for 'S.P'
> I have already run this grant successfully
> GRANT EXECUTE ON S.P TO R
> Running 10.2.0.2