Home » RDBMS Server » Server Administration » user question
user question [message #370046] Tue, 05 December 2000 04:29 Go to next message
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 Go to previous message
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
Previous Topic: user question
Next Topic: Number of rows
Goto Forum:
  


Current Time: Sun Dec 22 19:14:16 CST 2024