I just created a new user, it DOES have create session, but everytime i try to connect on PLSQL Developer I get ORA-00604, ORA-01722 and ORA-06512
However, if i grant DBA access, i can log on with no problems.
Hints? I don't have any connection trigger.
ORA-01722 indicates some code is hurling an INVALID_NUMBER exception.
Connect as a DBA and have a look in DBA_TRIGGERS. Is there an AFTER LOGON trigger? If so, look at the code in the trigger body. Is there anything which is doing a TO_NUMBER() conversion; remember to consider implicit conversion (inserting a non-numeric value into a numeric column, etc).
Regular users are stymied by errors in LOGON triggers but DBAs get a free pass. Otherwise, who would be able to connect to the database and fix the problem?
ORA-01722 is INVALID_NUMBER
Maybe PL/SQL developer is trying to execute something on connection.
If you are absolutely doubly sure that there isn't a connection trigger (and look for a database level one), then create one for that schema that enables a trace. Then look in the trace file for the 1722 error and see what statement it is trying to execute.
ORA-00604 : If you're running 11g check this link. There are apparently several issues with 11g that can cause ORA-00604 errors to pop up unexpectedly.
Share and enjoy.