Home » RDBMS Server » Security » ORA-01031: insufficient privileges (oracle 9i, OS XP)
ORA-01031: insufficient privileges [message #362469] Tue, 02 December 2008 06:47 Go to next message
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 #362475 is a reply to message #362469] Tue, 02 December 2008 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You need to be SYS and only SYS (or SYSDBA) to compile SYS objects.

Regards
Michel
Re: ORA-01031: insufficient privileges [message #362498 is a reply to message #362475] Tue, 02 December 2008 08:18 Go to previous messageGo to next message
overcrash
Messages: 2
Registered: December 2008
Junior Member
Thanks Michel for your reply,
but i thought,any user can compile sys.objects once i gave him grant execute any procedure although he is not the owner.

appreciate your reply.
Re: ORA-01031: insufficient privileges [message #362507 is a reply to message #362498] Tue, 02 December 2008 08:45 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Try GRANT ALTER ANY PROCEDURE.
Re: ORA-01031: insufficient privileges [message #362508 is a reply to message #362507] Tue, 02 December 2008 08:55 Go to previous message
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
Previous Topic: Oracle Database
Next Topic: SELECT_CATALOG_ROLE
Goto Forum:
  


Current Time: Thu Dec 05 06:55:22 CST 2024