-
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
-
-
-
never mind...i fixed it.
the user was missing 'create procedure...'....basics :-(
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
|