mass password change in version 9 pl 15
one of my customers has 50 databases
frequently the customer adds new user to all of the databases using a special add on
the problem is with the passwords.
the customer wouldnt enter each of the 50 companies to set a password to the new user.
i have a special procedure that can run SQL queries on all databases
but i have read here in the forum that passwords are encypted so it wont help to copy it.
i have read another disscusion here that says if the private key and user id are the same in all db's than you can copy the password
but i didnt understad what does private key mean? is it internal_k?
anyway, i have tried that with internal key and it didnt work.
do you have some advise?