Re: ORA-01720: grant option does not exist for 'S.P'
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Wed, 11 Nov 2009 20:55:24 +0100
Message-Id: <58AD8673-23BB-4624-8CAC-E1AB4E6A9EA8_at_gmail.com>
Just to make sure, do you have Datbase Vault on this system?
Date: Wed, 11 Nov 2009 20:55:24 +0100
Message-Id: <58AD8673-23BB-4624-8CAC-E1AB4E6A9EA8_at_gmail.com>
Just to make sure, do you have Datbase Vault on this system?
Martin
> 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'
>
> P.S
> I have already run this grant successfully
> GRANT EXECUTE ON S.P TO R
>
> Running 10.2.0.2
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 11 2009 - 13:55:24 CST