ORA-01720: grant option does not exist
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01720: grant option does not exist

  1. #1
    Join Date
    May 2002
    Location
    England
    Posts
    78

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    hr_contract_api is owned by apps? Are you logged in as "apps" when applying the grant on the view?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2002
    Location
    England
    Posts
    78
    yep logged on as apps and package is owned by apps

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    package?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    May 2002
    Location
    England
    Posts
    78
    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
  •  


Click Here to Expand Forum to Full Width