That's correct. And yes a script will work...

-----Original Message-----
From: edwinuy
[mailto:oracledba-ezmlmshield-x456649.[Email address protected]
Sent: Tuesday, August 31, 2004 12:51 PM
To: LazyDBA Discussion
Subject: can i do this ..???


hi all,

need to change some users' password on multiple instance, can I do this it
like this?

connect system/[Email Address Removed] user 111 identified by aaa
connect system/[Email Address Removed] user 222 identified by bbb
connect system/[Email Address Removed] user 333 identified by ccc

and so on ... anyone who have a script that can do the same, possibly one
where I can have the sids, the users and the passwords into an array that i
can loop into ...


Cheers,

EDWIN ONG UY
UNIT 4,64 GRANGE ROAD
MT EDEN 1003
AUCKLAND, NEW ZEALAND
Email: [Email address protected]
Mobile: 64-021-622092

-------------------------------------
This email is intended solely for the named recipient/s and as such is
confidential and may contain information that is privileged. If you have
received it by mistake, please notify the sender. You must not use, copy,
distribute or disclose its contents to anyone other than the addressee. This
email and any attachments might not be free from computer viruses or other
defects.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page