logicaltrinkets

I created a new user with

SQL> create user "reac" identified by "reac";

but when I tried to login with it gave me

ERROR:
ORA-01017: invalid username/password; logon denied

This was on a windows 7 64 bit with Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production.

It turns out Oracle didn’t like the lower case names. go figure.

some other things you might want to do

SQL> alter user "REAC" account unlock;

User altered.

SQL> grant connect to "REAC";

Grant succeeded.

SQL> grant DBA to "REAC";

Grant succeeded.

SQL> grant RESOURCE to "REAC";

Grant succeeded.