Home » SQL & PL/SQL » SQL & PL/SQL » Ora-01031
icon1.gif  Ora-01031 [message #273053] Mon, 08 October 2007 23:18 Go to next message
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
I am working on sqldeveloper to create Materialized view getting ORA-01031 error how to resolved this error
Re: Ora-01031 [message #273054 is a reply to message #273053] Mon, 08 October 2007 23:20 Go to previous messageGo to next message
Messages: 25537
Registered: January 2009
Location: SoCal
Senior Member
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may occur
//         if the user was granted the necessary privilege at a higher label
//         than the current login.
// *Action: Ask the database administrator to perform the operation or grant
//          the required privileges.
//          For Trusted Oracle users getting this error although granted the
//          the appropriate privilege at a higher label, ask the database
//          administrator to regrant the privilege at the appropriate label.

Part of me suspects you could benefit from remedial CUT & PASTE training

[Updated on: Mon, 08 October 2007 23:21] by Moderator

Report message to a moderator

Re: Ora-01031 [message #273095 is a reply to message #273053] Tue, 09 October 2007 01:40 Go to previous message
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
Previous Topic: Need PL/SQL FAQ
Next Topic: comma separated output
Goto Forum:

Current Time: Tue Jul 25 13:56:48 CDT 2017

Total time taken to generate the page: 0.05160 seconds