Re: Create account ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 17 Jul 1999 14:11:16 +0800
Message-ID: <37901E84.6663@yahoo.com>

MARANDEL Benjamin wrote:
>
> Hi !
>
> I have finish to install Oracle8, but i have a problem, i have use
> Oracle as a client,
> but i have never administrate a server, so i dont't know how to create
> user to acces to database.
> When i run sqlplus, i need a username and password, i don't know what i
> can test !!!
>
> Sory for my bad english, but i'm a french beginner administrator on
> linux, so, please
> help me !!!!
>
> Thanks.
>
> --
> Benjamin MARANDEL Administrateur Linux
> marandel_at_ws-interactive.fr Developpeur base de donnee
> ________________________________________________________
> WS Interactive - 15 Quai Lombard - 31000 Toulouse FRANCE
> Tel. 05 62 30 80 70 - Fax. 05 62 30 25 45
> Visitez notre site web : http://www.ws-interactive.fr
> ________________________________________________________

sys/change_on_install
system/manager

connect as either and you can issue:

create user XYZ
identified by ABC
default tablespace users
temporary tablespace temp;

grant create session to XYZ;

which creates a user XYZ with password ABC and allows them to connect to the database...

Cheers
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Jul 17 1999 - 01:11:16 CDT