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.