Re: Add A User In Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 2 May 2001 18:48:21 +0200
Message-ID: <tf0eel1ohos3df_at_beta-news.demon.nl>


"Chris ( Val )" <XCHRISVAL_at_bigpond.com.au> wrote in message [Quoted] news:RSVH6.16500$482.83289_at_newsfeeds.bigpond.com...
> Thanks a million Jerry, worked like a dream...
> Just a quick question, is there a GUI for 8i
> personel edition to achieve this, because I only
> did a typical install as the readme file suggested
> and I cant find it anywhere. And can you also
> change the host string with the command line as
> you have shown rather than editing the Tnsnames.ora
> file in the oracle directory?
>
> Thanks again
> Chris Val
>
>
> "Jerry Metz" <jmetz1_at_ix.netcom.com> wrote in message
> news:3AF02950.712B45E3_at_ix.netcom.com...
> | Log in to Oracle SQL*Plus as the system account (password is probably
 manager)
> | type the following:
> | create user xxxxxxxx identified by yyyyyyyy;
> | (the x's indicate the new user name and the
> | y's indicate the password that the new account
 should use)
> | then type:
> | grant dba, connect, resource to xxxxxxxxx;
> | (where xxxxxxxxxx is the new username)
> |
> | You can then log into the database using the new user name and password
 that
 you
> | have just created.
> | Don't forget the semicolon at the end of the commands. Good Luck.
> | Jerry
> |
> | "Chris ( Val )" wrote:
> |
> | > Its the first time I've ever installed it and I only
> | > did it once.
> | >
> | > Thanks
> | > Chris Val
> | >
> | > "Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message
> | > news:_FSH6.16877$%N.152564_at_skycache.prestige.net...
> | > | Chris,
> | > | How many times did you install Oracle Personal? :)
> | > |
> | > | Go look in comp.databases.oracle.server, someone has already
 answered
 this
> | > | question for someone else.
> | > |
> | > | Also, try deja.com to search these news groups.
> | > |
> | > |
> | > | "Chris ( Val )" <XCHRISVAL_at_bigpond.com.au> wrote in message
> | > | news:reSH6.16232$482.82736_at_newsfeeds.bigpond.com...
> | > | > Hi everybody, I've just installed Oracle Personel
> | > | > edition 8i for the first time, I followed all the instructions
> | > | > in the readme file and got it set up and tested fine on
> | > | > my machine Win98 SE.
> | > | >
> | > | > What I would like to know is this:
> | > | > Is it possible to add a new user account with the personel
> | > | > edition of 8i?
> | > | > I have looked everywhere but cannot find anywhere where
> | > | > to do this, I did a typical install as the readme file suggested
> | > | > so is it also possible that the administration part for adding
> | > | > user accounts was not installed by doing this?
> | > | >
> | > | > All and any help truely appreciated.
> | > | > Chris
> | > | >
> | > | >
> | > | >
> | > | >
> | > | >
> | > |
> | > |
> |
>
>

If you did a typical install, you installed .... manuals. And don't say you can't find them, just look better! Please use them before you start posting!

Regards,

Sybrand Bakker, Oracle DBA Received on Wed May 02 2001 - 18:48:21 CEST

Original text of this message