How to generate password oracle randomly?

Asked By 30 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 590495 points N/A #143203

How to generate password oracle randomly?

qa-featured

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.

Related Questions