Can't grant execute permissions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can't grant execute permissions

  1. #1
    Join Date
    May 2002
    Posts
    1

    Angry

    I have recently installed Oracle 8i on a Windows NT machine and imported a database that is the backend for a website. After import, the user that the website uses to log in does not have permissions to execute any of the packages.

    I have tried granting permission while logged in as System, Sys, Scott and the schema owner of the packages, and keep getting an error that I don't have the rights to assign those permissions.
    Any ideas?

    No passwords or user names have been changed or added except the one that the website uses to log in.

    Thanks,
    Jessica Jones

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    What error message/number are you getting?

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    try recompiling your packages and any other invalid options

    Usually after importing most of the packages gets invalid u need to recompile all . since u have not changed any permissions after importing ans i presume you have done full database import .

    siva prakash
    DBA

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