+ Reply to Thread
Results 1 to 4 of 4
  1. 03-20-2004 12:24 PM #1
    ADBA007
    ADBA007 is offline Junior Member
    Join Date
    Feb 2004
    Posts
    35

    ORA-01031 when creatinf procedures/packages

    Hello,
    I used fromuser/touser with export/import to copy data from user1 to user2. All the tables are imported without any problem. However, the stored procedures and packages failed with "ORA-01031: insufficient privileges".
    I tried to created then directly (not import_ but got the same error. Is user2 missing any grants (like create packages etc.?)

    Thanks
    Reply With Quote Reply With Quote
  2. 03-20-2004 09:59 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    you're missing privs...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Reply With Quote Reply With Quote
  3. 03-20-2004 10:38 PM #3
    ADBA007
    ADBA007 is offline Junior Member
    Join Date
    Feb 2004
    Posts
    35
    thanks, but which one?
    Reply With Quote Reply With Quote
  4. 03-21-2004 01:05 AM #4
    ADBA007
    ADBA007 is offline Junior Member
    Join Date
    Feb 2004
    Posts
    35
    never mind...i fixed it.
    the user was missing 'create procedure...'....basics :-(
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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