| ORA-01031: insufficient privileges [message #362469] |
Tue, 02 December 2008 06:47  |
overcrash
Messages: 2
Registered: December 2008
|
Junior Member |
|
|
Environment is :
OS Xp , Oracle 9i , forms 6i in the same machine, not connected to network.
Pre-problem : i created user1 with all grants,and roles
DBA,Resource,Connect and public.
Event : i'm trying to compile "sys.owa_sec" package
from forms6i , sql plus,entrprise manager.
Problem : i got the same error :
-ORA-01031: insufficient privileges
-you do not have enough privileges to perform this operation
-you must have the appropriate system and object privileges
to create edit or drop database objects or objects outside of your schema
i know this problem is common to happen, also i make the required grants.
so if any one can help, please reply, thanks in adavance
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01031: insufficient privileges [message #362508 is a reply to message #362507] |
Tue, 02 December 2008 08:55  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
This does not work with SYS objects:
SYS> create user test identified by test;
User created.
SYS> grant create session, alter any procedure to test;
Grant succeeded.
SYS> create or replace procedure michel_test as begin null; end;
2 /
Procedure created.
SYS> connect test/test
Connected.
TEST> alter procedure sys.michel_test compile;
alter procedure sys.michel_test compile
*
ERROR at line 1:
ORA-01031: insufficient privileges
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
