ORA-04045 and ORA-01031
Posted on 2011-03-22
I've got an Oracle 9i, Windows Server 2003. Yesterday, I created a new instance and run catalog.sql and catproc.sql. Today, I can't logon with any normal user into database (i.e: scott/tiger). I can only logon with system or a user with dba role.
With any other user I got this error when trying to logon:
ORA-04045: errors during recompilation/revalidation of SIGA01.DATA_LOGON_TRIGGER
ORA-01031: insufficient provileges
SIGA01 is an schema created in my database.
I read that the real error is ORA-01031, that there's something missing to recompile.
What could be it?