ORA-01720: grant option does not exist
Running an oracle supplied script against my database for Apps 11i and I get the following error on 220.127.116.11.
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
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.
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
yes apps.hr_contract_api is a package, and apps.per_contract_x is a view which uses this package.
Click Here to Expand Forum to Full Width