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?
In Toad 10 a script option was included when generating User scripts to apply the IDENTIFIED BY VALUES (current password value).
There are 3 main ways of creating USER scripts. Enable the password option when creating the USER script:
1. In Database | Export | Export DDL | Script Options | Users -- enable "If possible, include Identified by values caluse in 11g."
2. Schema Browser | User, right click on a user | Create Script | Script Options | Users -- enable "If possible, include Identified by values caluse in 11g."
3. In Database | Generate Schema Script | Script Options | Other Objects -- "Include password in 11g and newer if possible."
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center