-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|