Re: Creating new users in XE

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 15 Oct 2006 19:40:16 +0100
Message-ID: <d4adnUFtGa4bHa_YRVnysg@pipex.net>

Stan Brown wrote:
> 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?
>

There's a create user screen in the GUI.

What I tend to do is to create a role (or in fact a couple) with some required privileges CREATE SESSION, CREATE TABLE etc etc   and then grant the role to the user.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

Received on Sun Oct 15 2006 - 13:40:16 CDT