ORA-01720: grant option does not exist

[jperusco]

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

[slimdave]

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

[jperusco]

yep logged on as apps and package is owned by apps

[slimdave]

package?

[jperusco]

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