Friday, September 23, 2011

ORA-01031:insufficient privileges

I was stuck with this particular error as part of running my UI. Now, you know for sure that there is some username / password that you are using which does not have the required grants or privileges. Or it is some security related issue.

The log inside jdeveloper could actually sometimes be misleading, in that it could show a SQLstatement exception for some unrelated tables (EOs, VOs, etc).

However, running the SQL query that was shown as part of the log inside the SQL worksheet in jdev actually gave me the clue. I was able to reproduce the same ORA error with the username and password as fs_runtime. However, the error was gone once I changed to username to fs.

I had to subsequently change the credentials inside the properties file and re-created the domain, to help get rid of the error in UI!

Alternatively, giving grants to the username that does not have the required grants also works fine!