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

Report message to a moderator

Re: changing passwords [message #199606 is a reply to message #199602] Wed, 25 October 2006 04:16 Go to previous message
Littlefoot
Messages: 21826
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.

Report message to a moderator

Previous Topic: Can I alter my own expired password from application level?
Next Topic: UNABLE TO LOGIN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 08 16:49:07 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.