Home » RDBMS Server » Security » SYS has insufficient priviledges
SYS has insufficient priviledges [message #271895] Wed, 03 October 2007 05:29 Go to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
We are working in RHEL 4.0 and Oracle 9.2.0.6. A database is created and also a dump is imported now when trying to compile a package in sys schema, its throwing "ORA-01031: insufficient privileges"; also when I am trying to login to that database from any client machine through sql*plus the same error message is shown.

Can you give me any idea why this is happening. How sys or system could have insufficient priviledges? Please help... and it is urgent.

Thanks and regards,
Sam G
Re: SYS has insufficient priviledges [message #271928 is a reply to message #271895] Wed, 03 October 2007 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read OraFAQ Forum Guide, especially what is said about word like "urgent".

Post (copy ansd paste) what you did.

Regards
Michel
Re: SYS has insufficient priviledges [message #272063 is a reply to message #271895] Wed, 03 October 2007 22:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

SQL> conn system/sistem
Connected.
SQL> alter package SYS.DBMS_REPCAT_INTERNAL_PACKAGE compile;
alter package SYS.DBMS_REPCAT_INTERNAL_PACKAGE compile
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL> alter package SYS.DBMS_REPCAT_INTERNAL_PACKAGE compile;

Package altered.
Re: SYS has insufficient priviledges [message #272064 is a reply to message #271895] Wed, 03 October 2007 22:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By the way, how do you think that this question is suitable on server utilities section?
Re: SYS has insufficient priviledges [message #272075 is a reply to message #272063] Wed, 03 October 2007 23:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why your title "SYS has insufficient priviledges" when your exemple shows it is OK?
SYSTEM does not have all privileges, especially on SYS objects.

Regards
Michel
Re: SYS has insufficient priviledges [message #277680 is a reply to message #272075] Wed, 31 October 2007 02:57 Go to previous messageGo to next message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
I granted execute, debug on that object to the particular user and now the problem is solved. Sorry for late answering.

Regards,
Sam G
Re: SYS has insufficient priviledges [message #279100 is a reply to message #271895] Tue, 06 November 2007 22:27 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Now re-justify your title.
Previous Topic: Oct 2007 CPU and Oracle 9.2.0.7
Next Topic: How to set Destination file for AUDIT_TRAIL=OS
Goto Forum:
  


Current Time: Thu Mar 28 06:07:14 CDT 2024