Re: Add A User In Oracle 8i

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tf0eel1ohos3df_at_beta-news.demon.nl...
|
| "Chris ( Val )" <XCHRISVAL_at_bigpond.com.au> wrote in message
| 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

Yes it did install some documentation of which I have looked through, its hard to find something if you dont know what to look for, thats why I posted in the first place.

Can you give me a hint on what the GUI for adding users is called so I will search it again.

Thank you
Chris Val Received on Thu May 03 2001 - 05:17:51 CEST