Home » RDBMS Server » Security » sequence to change db users passwords (Oracle 10g R2)
icon5.gif  sequence to change db users passwords [message #358349] Mon, 10 November 2008 17:36 Go to next message
juanc.erazo
Messages: 8
Registered: November 2008
Location: Colombia
Junior Member
Hi all, is there any sequence to change db users passwords? I mean, first change scott user password, next system user password, next sys user password and so on?
Re: sequence to change db users passwords [message #358371 is a reply to message #358349] Tue, 11 November 2008 00:30 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, you can change any password whenever you want. Or, you don't have to change any of them ever (not a very smart idea, though).

However, note that certain database features may suffer from password changes (such as database links, for example, which depend on a password).
Re: sequence to change db users passwords [message #358460 is a reply to message #358371] Tue, 11 November 2008 07:53 Go to previous message
juanc.erazo
Messages: 8
Registered: November 2008
Location: Colombia
Junior Member
OK, great, i'm sure about problems with some features whenever i change a db user password but our SOX auditing claim for this. Thanks for your reply.
Previous Topic: OID - Importance of Wallet in OID without SSL and Other problems
Next Topic: conn /as sysdba;
Goto Forum:
  


Current Time: Tue Apr 16 18:29:30 CDT 2024