Easily find issues by searching: #<Issue ID>
Example: #1832
| 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
| Field | Old Value | New Value |
|---|---|---|
| Resolution | Fixed | |
| Resolved Date | Sep 12, 2011 4:54 PM | |
| Status | New | Resolved |
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.
| Field | Old Value | New Value |
|---|---|---|
| QA Assignee | NielsGron (Niels Gron) | tariqrahiman (Tariq Rahiman) |
| Field | Old Value | New Value |
|---|---|---|
| Fixed Build | 10.0.0-rc-13_09 | |
| Status | Resolved | Closed |
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.