Home » RDBMS Server » Security » Creating a new user account in Personal Oracle 8 on Win NT/2000
Creating a new user account in Personal Oracle 8 on Win NT/2000 [message #431] Mon, 11 February 2002 23:54 Go to next message
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
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 Go to previous message
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
Previous Topic: Oracle 8 - users & roles
Next Topic: Privilege for Creating Package\Procedure
Goto Forum:
  


Current Time: Fri Mar 29 06:25:29 CDT 2024