Home » RDBMS Server » Security » changing passwords
changing passwords [message #199602] Wed, 25 October 2006 04:09 Go to next message
gmkreddy
Messages: 9
Registered: October 2006
Location: Hyderabad
Junior Member

\
hi guys

i want to change at a time 200 users passwords

how can i change at a time


thanks
gmkreddy
Re: changing passwords [message #199606 is a reply to message #199602] Wed, 25 October 2006 04:16 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
All 200 of them would have the same password? If so, is it a good idea?

If you can identify those users, write a PL/SQL script and alter users using EXECUTE IMMEDIATE.
Another option would be writing a script file with 200 ALTER USER statements and running it from SQL*Plus.

Perhaps there is another way to do it, but I don't know anything about it.
Previous Topic: Can I alter my own expired password from application level?
Next Topic: UNABLE TO LOGIN
Goto Forum:
  


Current Time: Thu Mar 28 20:47:22 CDT 2024