Home » RDBMS Server » Server Administration » Oracle query
Oracle query [message #55624] Tue, 04 February 2003 22:19 Go to next message
chinni
Messages: 3
Registered: February 2003
Junior Member
Sir,

Could you plz tell me why the default username for Oracle is "scott" & password is "tiger" & Tell me is it possible to change "tiger" & give user defined password

Thanking you
chinni

Report message to a moderator

Re: Oracle query [message #55625 is a reply to message #55624] Wed, 05 February 2003 01:49 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Of course you can do that. First, you connect to the database either as SCOTT or with someone who has the ALTER ANY USER privilege, like the DBA (SYS or SYSTEM e.g.).
Issue the following command:
ALTER USER SCOTT IDENTIFIED BY new_password;

That's all there's to it.

MHE

Report message to a moderator

Re: Oracle query [message #55646 is a reply to message #55624] Thu, 06 February 2003 09:39 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
The story on Scott/Tiger is correct as the instructor in the Oracle ILT class mentioned it.

But I think that Scott had a cat named 'tiger' and not his daughter...

Report message to a moderator

Previous Topic: email trigger
Next Topic: Re: archive log list doesn't work as sysdba
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:22:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.