ORA-01031 : Insufficient Privileges

ORA-01031 is generated by oracle in most cases when the user lacks privileges to perform the particular operation. In generic cases, ORA-01031 error is thrown when the user is unable to create an object like table, view procedure etc., due to an incorrect setup in the security layer. In some cases ORA-01031 can also happen during instance startup.

ORA-01031 : Insufficient Privileges 

ORA-01031 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.

ORA-01031 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.