ORA-01720: grant option does not exist

Hi All,

Running an oracle supplied script against my database for Apps 11i and I get the following error on 9.2.0.2.

ORA-01720: grant option does not exist for 'APPS.HR_CONTRACT_API'
when I run
grant select on apps.per_contracts_x to hr_reporting_user;

I have been working on this for over a day now and can't get anywhere, I have also raised a tar and not surprisingly its a work in progress.

Points to Note:
hr_reporting_user is a role and per_contracts_x is a view which uses
hr_contract_api.

Now logic would dictate that the simple solution is...

grant execute on hr_contract_api to hr_reporting_user;

Unfortunately this doesn't work!

This one is driving me mad! Not sure if I am dealing with a bug but I am running out of things to try.

Any help would be greatly appreciated.

Cheers
John

hr_contract_api is owned by apps? Are you logged in as "apps" when applying the grant on the view?

yep logged on as apps and package is owned by apps

package?

yes apps.hr_contract_api is a package, and apps.per_contract_x is a view which uses this package.