Re: Creating new users in XE

On Sat, 14 Oct 2006 19:01:37 +0000 (UTC), Stan Brown <stanb_at_panix.com> wrote:

>I just installed the Debian XE package on an Ubuntu machine.
>
>I can connect with sqlplus as system. Then I:
>
>create user "stan" identified by "xxx" ;
>
>Says user created, but when I try to connect as this user via sqlpus, I get
>badd username/password pair.
>
>It's been a while since I had to create users in a new instance, what am I
>forgetting?

 Don't use the double quotes around the username or password, as this actually makes it considerably harder to log in (it forces case-sensitivity on the user, which is unusual, and so you'd also need the quotes when trying to connect).

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> create user "stan" identified by stan;

User created.

SQL> connect stan_at_xe_excession
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE. SQL> connect "stan"@xe_excession
Enter password:
ERROR:
ORA-01045: user stan lacks CREATE SESSION privilege; logon denied

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool