When creating User scripts, Toad does not include the password in the IDENTIFIED BY values when connected to 12c database. (4234726)

When creating User scripts, Toad does not include the password in the IDENTIFIED BY values when connected to 12c database.

When creating User scripts, Toad does not include the encrypted password in the IDENTIFIED BY values when connected to an Oracle 12c database.

In 11g, Oracle moved the PASSWORD out of DBA_USERS, so you only had access to it if you could select from SYS.USER$.  In 11g (and all versions prior), SELECT on SYS.USER$ was included in the SELECT ANY DICTIONARY system privilege.

In 12c, SYS.USER$ is no longer included in the SELECT ANY DICTIONARY system privilege.  So in 12c, the only way you’ll see the password is if you log in as SYS or if SELECT on SYS.USER$ is explicitly granted.

In order for the  password to show in the user script, login as SYS as SYSDBA or explicitly grant select on sys.user$ to your user (for example: "grant select on sys.user$ to scott;").

Next, go to the Schema Browser | Users Tab | Script Tab | and click the "View/Edit Script Options" icon in the toolbar (right below the 'Info' Tab).

The 'Script Options' window will appear.  

Next, go to the 'Users' Tab (right next to the 'Common' Tab) | and check-mark the option, >> "If possible, include "Identified by values" clause in 11g and newer" <<.  

Click OK | restart your connections or Toad | and re-test the issue.