Generates a pseudorandom password that satisfies the global password complexity checks defined on the SAP ASE server. “Pseudorandom” indicates that the SAP ASE server is simulating random-like numbers, since no computer generates truly random numbers.
password_random ([pwdlen])
minimum password length: 10 min digits in password: 2 min alpha in password: 4 min upper char in password: 1 min special char in password: -1 min lower char in password: 1 select password_random() ---------------------- 6pY5l6UT]Q
minimum password length: 15 minimum digits in password: 4 minimum alpha in password: 4 minimum upper-case characters in password: 1 minimum lower-case characters in password: 2 minimum special characters in password: 4 select password_random(25) ----------------- S/03iuX[ISi:Y=?8f.[eH%P51
update employee set password = password_random() where name like 'A%'
select @password = password_random(11) ----------- %k55Mmf/2U2 sp_adlogin 'jdoe','%k55Mmf/2U2'
The passwords generated by password_random() are pseudorandom; to generate truly random passwords, use a stronger random generator.
Minimum password length
Digits in password
Special characters in password
Alphabetic characters in password
Uppercase characters in password
Lowercase characters in password