Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating new users in XE
In <egrg52$bu6$1_at_reader1.panix.com> Stan Brown <stanb_at_panix.com> writes:
>In <jae2j25vefur5ecr4b0ltssj0a6ib8ose9_at_4ax.com> Andy Hassall <andy_at_andyh.co.uk> writes:
>>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
>Cool, thaks, I'll drop and recreate those users.
Well that got me further along, but now when I try to connect via sqlplus I get an "user lacks CREATE SESSION" privelege. I supose I can keep using alter till I get what I need, but is there a way to create a working user from a template, or in one step, or something?
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Sat Oct 14 2006 - 15:16:50 CDT