-
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
-
-
yes apps.hr_contract_api is a package, and apps.per_contract_x is a view which uses this package.
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
|