tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

Oracle/PLSQL: ORA-01031

Learn the cause and how to resolve the ORA-01031 error message in Oracle.


When you encounter an ORA-01031 error, the following error message will appear:

  • ORA-01031: insufficient privileges


You attempted to perform an operation for which you do not have the appropriate privileges. Some of the more common causes are:

  1. You tried to change an Oracle username or password without having the appropriate privileges.
  2. You tried to perform an UPDATE to a table, but you only have SELECT access to the table.
  3. You tried to start up an Oracle database using CONNECT INTERNAL.
  4. You tried to install an Oracle database without having the appropriate privileges to the operating-system.
Share this page:


The option(s) to resolve this Oracle error are:

Option #1

You can have the Oracle DBA grant you the appropriate privileges that you are missing.

Option #2

You can have the Oracle DBA execute the operation for you.

Option #3

If you are having trouble starting up Oracle, you may need to add the Oracle user to the dba group.