| Logging on to SQL*Plus [message #99883] |
Thu, 09 May 2002 04:34  |
andy
Messages: 92
Registered: December 1999
|
Member |
|
|
|
I've just installed Oracle 8i personal edition on my Windows 98 machine but when I try to log into SQL*PLUS I'm prompted for a user/password/host string - yet I wasn't prompted for any of this during the install. I tried my windows login but no luck. Can anybody help?
|
|
|
|
| Re: Logging on to SQL*Plus [message #99890 is a reply to message #99883] |
Thu, 09 May 2002 20:27  |
S Jesse - Coauthor Oracle
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
On Oracle8i, Oracle creates 3 basic accounts by default:
Internal (passowrd is probably oracle). Used for starting up and shutting down the database, and is 'all powerful'.
Sys - Password is change_on_install. SYS and Internal are basically equivalent, except that SYS on its own cannot shutdown/startup. SYS owns the data dictionary (metadata objects are owned by SYS)
System - password is manager. System is a basic DBA account, who also owns some data dictionary objects.
You should avoid logging in and creating objects as any of these accounts. once you are logged into SQL*Plus, you can create new users with some basic commands such as:
SQL> Create user x identified by y default tablespace users;
SQL> grant connect, resource to x;
SQL> connect x/y
(This will connect you as user x).
This is very basic info, but hopefully it is enough to at least get you logged in to SQL*Plus :-) !!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
