OraFAQ Forum: Security » SYS has insufficient priviledges

Home » RDBMS Server » Security » SYS has insufficient priviledges

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

SYS has insufficient priviledges [message #271895]

Wed, 03 October 2007 05:29

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

Report message to a moderator

Re: SYS has insufficient priviledges [message #271928 is a reply to message #271895]

Wed, 03 October 2007 06:52

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

Report message to a moderator

Re: SYS has insufficient priviledges [message #272063 is a reply to message #271895]

Wed, 03 October 2007 22:23

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.

Report message to a moderator

Re: SYS has insufficient priviledges [message #272064 is a reply to message #271895]

Wed, 03 October 2007 22:24

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?

Report message to a moderator

Re: SYS has insufficient priviledges [message #272075 is a reply to message #272063]

Wed, 03 October 2007 23:40

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

Report message to a moderator