Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news-lond.gip.net!news.gsl.net!gip.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed-00.mathworks.com!panix!stanb
From: Stan Brown <stanb@panix.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Creating new users in XE
Date: Sat, 14 Oct 2006 20:09:06 +0000 (UTC)
Organization: PANIX Public Access Internet and UNIX, NYC
Lines: 44
Message-ID: <egrg52$bu6$1@reader1.panix.com>
References: <egrc6h$ina$1@reader1.panix.com> <jae2j25vefur5ecr4b0ltssj0a6ib8ose9@4ax.com>
NNTP-Posting-Host: panix2.panix.com
X-Trace: reader1.panix.com 1160856546 12230 166.84.1.2 (14 Oct 2006 20:09:06 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: Sat, 14 Oct 2006 20:09:06 +0000 (UTC)
User-Agent: nn/6.7.2
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:277306

In <jae2j25vefur5ecr4b0ltssj0a6ib8ose9@4ax.com> Andy Hassall <andy@andyh.co.uk> writes:

>On Sat, 14 Oct 2006 19:01:37 +0000 (UTC), Stan Brown <stanb@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@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

Cool, thaks, I'll drop and recreate those users.
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin