When creating User scripts, it does not include the password in the "IDENTIFIED BY VALUES" clause.
Toad 9.5 release notes states:
"In Oracle 11g, passwords are no longer stored in encrypted form in dba_users. So Toad cannot create user scripts with the IDENTIFIED BY VALUES clause. Instead, the script will have IDENTIFIED BY <password>, and the user will have to fill in the password before running the script."
Is there another option to automatically include the current password into the create scripts? Why can't Toad query the PASSWORD column from SYS.USER$ table instead so it can use the IDENTIFIED BY VALUES clause when creating a new user?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center