Oracle: Create new user 11g

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.

Leave a Comment


*


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>