SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create a procedure to change randomly passwords

857281Apr 23 2011 — edited Apr 23 2011

Hello,

I am trying to create a procedure to change randomly passwords for all users in a database. I need this after the database cloning. I have too many users to alter in a manual way...

Is there any option to create a procedure which will fetch all users in a database and alter them by a random password?

I was not able to find any clue.

Could you help me?

Thanks

This post has been answered by Hoek on Apr 23 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2011

Added on Apr 23 2011

#password

8 comments

1,066 views