user question [message #370046] |
Tue, 05 December 2000 04:29 |
prashant
Messages: 122 Registered: September 2000
|
Senior Member |
|
|
i want to chang my user pass in oracle
default user scott and pass tiger
plese tell me how to change thi user name and pass .
|
|
|
Re: user question [message #370049 is a reply to message #370046] |
Tue, 05 December 2000 04:50 |
Balasubramanian.C
Messages: 5 Registered: November 2000
|
Junior Member |
|
|
solution is
ALTER USER username
IDENTIFIED BY password
type this sql statment in sql prompt
and give your username and give newpassword
instead of old password
u will get
the result as USER ALTERED
|
|
|