OraFAQ Forum: Security » Creating a new user account in Personal Oracle 8 on Win NT/2000

Home » RDBMS Server » Security » Creating a new user account in Personal Oracle 8 on Win NT/2000

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating a new user account in Personal Oracle 8 on Win NT/2000 [message #431]

Mon, 11 February 2002 23:54

Suddha Satta Ray
Messages: 5
Registered: February 2002

Junior Member

I have just installed Personal Oracle 8 on Windows 2000.

Please tell me how do I :

1. Get into SQL Plus ?
2. Create more user accounts ?

Thank You.
Suddha Satta Ray

Report message to a moderator

Re: Creating a new user account in Personal Oracle 8 on Win NT/2000 [message #434 is a reply to message #431]

Tue, 12 February 2002 00:54

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

1.go to sql/plus
2.connect as system
3.create user pratap identified by pratap
default tablespace xyz..
temporary tablespace temp..
4. grant connect,resource to pratap

Report message to a moderator

Previous Topic:	Oracle 8 - users & roles
Next Topic:	Privilege for Creating Package\Procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 19:15:58 CST 2025