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
ashishmcajec
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
BlackSwan
Messages: 26766
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
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
See
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_6002.htm#i2162987
Previous Topic: Need PL/SQL FAQ
Next Topic: comma separated output
Goto Forum:
  


Current Time: Fri Feb 07 22:11:34 CST 2025