Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Server Script Gen |
| Version | 10.0 |
For Oracle 11 the password of an oracle user is not stored in dba_users any more. In ServerScriptGenerator the password is listed as "null" (tested for ADS 9.0.16 an ADS 10.0 RC12)
The following select-Statement works for all Oracle-Versions.
SQL>set long 99999
SQL>select dbms_Metadata.get_ddl ('USER', 'SCOTT') from dual;
|
|
44 KB
Oracle 11g uses SHA-1 to hash the concatenation of (password||salt) and no longer saves it in the *_USERS table under password.
The system table USER$ does have the encrypted information we are looking for.
For oracle 11 and above now the server user extraction will join this table and retrieve the encrypted password from this table.
Issue #6039 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 10.0.0-rc-13_09 |
| No time estimate |
Oracle 11g uses SHA-1 to hash the concatenation of (password||salt) and no longer saves it in the *_USERS table under password.
The system table USER$ does have the encrypted information we are looking for.
For oracle 11 and above now the server user extraction will join this table and retrieve the encrypted password from this table.