Home » SQL & PL/SQL » Client Tools » Newbie for Oracle 9i
Newbie for Oracle 9i [message #254172] Thu, 26 July 2007 01:29 Go to next message
Messages: 1
Registered: June 2007
Junior Member
I am Newbie for Oracle 9i. I have installed Oracle 9i in my pc & configured in TOAD also in the name of SYSTEM & MANAGER in Database name : XXXXXX . How can i change my default user name & pasward.

Thansk in advance.
Re: Newbie for Oracle 9i [message #254182 is a reply to message #254172] Thu, 26 July 2007 01:55 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
As a DBA user you need to create your own user (look up the CREATE USER SQL command in the manuals) and give that user the necessary rights. You can alter the password of a user through the 'ALTER USER xxx IDENTIFIED BY newpassword;' command.

Re: Newbie for Oracle 9i [message #262525 is a reply to message #254172] Mon, 27 August 2007 06:36 Go to previous message
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
whenever you connect by toad, there is an option when toad startup, If u want to default connect to any schema set auto connect option on.
Previous Topic: transfer Data in tables into Excel sheet
Next Topic: errors login at SQLPLUS
Goto Forum:

Current Time: Tue Oct 25 02:43:37 CDT 2016

Total time taken to generate the page: 0.22048 seconds