How to generate password oracle randomly?

Asked By ingridgonzalou 30 points N/A Posted on - 09/12/2012

How to generate password oracle randomly and program it in such a way that old passwords expire after a definite time and new passwords get logged in a file that can be accessed easily?

• Status: Open
• Question Views: 865
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Sharath Reddy 590495 points N/A #143203

How to generate password oracle randomly?

Generating random numbers is required when there is a need to create a lot of data for testing purposes or when we simply need to use a number to temporarily tag a process. It may also be necessary to generate random password strings of fixed size which is a very common requirement for websites that create and maintain logins for users.

The DBMS_RANDOM package will generate random data in character, numeric or alphanumeric formats. The size and the range from which to pickup the random values can also be specified. This package is created by the script dbmsrand.sql available in the <ORACLE_HOME>/rdbms/admin directory. For further information on how to exactly do this, you may visit Generating Oracle random numbers and strings.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 08/18/2013
• Question Category: Oracle Database