OraFAQ Forum: Security » how to change the internal user passowrd

Home » RDBMS Server » Security » how to change the internal user passowrd

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to change the internal user passowrd [message #231506]

Tue, 17 April 2007 05:55

emind
Messages: 49
Registered: April 2007
Location: Islamabad

Member

in Oracle 8i how we can change the internal user password.

Report message to a moderator

Re: how to change the internal user passowrd [message #231510 is a reply to message #231506]

Tue, 17 April 2007 06:24

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter user sys identified by ...;

In addtion, don't use internal, use SYS.

Regards
Michel

Report message to a moderator

Re: how to change the internal user passowrd [message #231531 is a reply to message #231510]

Tue, 17 April 2007 07:19

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
In addtion, don't use internal, use SYS.
And also don't use SYS user.

SYS user is very special user and it is for only database internal work. for rountine work you can use SYSTEM or create your new user.

Regards
Taj

Report message to a moderator

Re: how to change the internal user passowrd [message #231559 is a reply to message #231531]

Tue, 17 April 2007 09:11

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I mean use SYS for maintenance as you used internal not for any other task.
Don't either use SYSTEM, create your DBA.
SYSTEM is for Oracle not for us.

Regards
Michel

Report message to a moderator

Previous Topic:	User Self Registration Force Password Change Issue
Next Topic:	hr/hr could not connect oracle 10g EM web interface

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 19:48:34 CST 2024