OraFAQ Forum: Security » ORA-01031: insufficient privileges

Home » RDBMS Server » Security » ORA-01031: insufficient privileges (oracle 9i, OS XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #362475 is a reply to message #362469]

Tue, 02 December 2008 07:10

Michel Cadot
Messages: 68758
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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #362498 is a reply to message #362475]

Tue, 02 December 2008 08:18

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.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #362507 is a reply to message #362498]

Tue, 02 December 2008 08:45

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Try GRANT ALTER ANY PROCEDURE.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #362508 is a reply to message #362507]

Tue, 02 December 2008 08:55

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not work with SYS objects:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Previous Topic:	Oracle Database
Next Topic:	SELECT_CATALOG_ROLE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 31 16:38:18 CDT 2025