Home » RDBMS Server » Security » how to change the internal user passowrd
how to change the internal user passowrd [message #231506] Tue, 17 April 2007 05:55 Go to next message
emind
Messages: 49
Registered: April 2007
Location: Islamabad
Member
in Oracle 8i how we can change the internal user password.
Re: how to change the internal user passowrd [message #231510 is a reply to message #231506] Tue, 17 April 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter user sys identified by ...;

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

Regards
Michel
Re: how to change the internal user passowrd [message #231531 is a reply to message #231510] Tue, 17 April 2007 07:19 Go to previous messageGo to next message
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
Re: how to change the internal user passowrd [message #231559 is a reply to message #231531] Tue, 17 April 2007 09:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: User Self Registration Force Password Change Issue
Next Topic: hr/hr could not connect oracle 10g EM web interface
Goto Forum:
  


Current Time: Thu Mar 28 13:00:01 CDT 2024