Home » Other » Client Tools » ORA-01031: insufficient privileges (11g, 11.2.0.1 window server)
ORA-01031: insufficient privileges [message #599649] Mon, 28 October 2013 01:04 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

While trying to logging to database through pl/sql developer, getting error as "ORA-01031: insufficient privileges".

But am able to logging by system.

As per the instruction by the below link, checked the privileges of ord_dba. All are correct. Now, i am in puzzle to rectify the error.
http://www.dba-oracle.com/t_ora_01031_insufficient_privileges.htm


Waiting for your kind assistance...

Regards,
Ishika
Re: ORA-01031: insufficient privileges [message #599656 is a reply to message #599649] Mon, 28 October 2013 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Check for any logon trigger.

Re: ORA-01031: insufficient privileges [message #599659 is a reply to message #599656] Mon, 28 October 2013 01:29 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

When I logon to server and start checking all the privileges. Found all are correct. Then I reset the password and then it allowed me to connect to sys through pl/sql developer.

Now, my problem is solved. But could understand the reason about is. Till yesterday i used to logon to sys. Suddenly, it pop-up error.

Regards,
Ishika
Re: ORA-01031: insufficient privileges [message #599683 is a reply to message #599659] Mon, 28 October 2013 03:00 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have not to logon as SYS but to manage the database itself not its content (startup/shutdown/backup...)
For the rest we have not enough information to diagnose.

Previous Topic: ora-01034 for users other than oracle
Next Topic: Oracle + Crystal Reports on Windows 7 64 Bit Machine
Goto Forum:
  


Current Time: Thu Mar 28 09:26:50 CDT 2024