Re: Creating new users in XE

In <d4adnUFtGa4bHa_YRVnysg_at_pipex.net> Niall Litchfield <niall.litchfield_at_dial.pipex.com> writes:

>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.

Thanks, I sucumbed to the easy way, an did it through the GUI. New concept to me, as I had never worked on a version new enough to have this feature before. I installed this using the ebian package on an Ubuntu machine, and it adde a menu item pointing to the GUI. Way too easy :-)

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin