Dbms_metadata.get_ddl('USER','<username>') Does Not Return A Password Value
(Doc ID 1529478.1)
Last updated on SEPTEMBER 19, 2023
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
If you are using DBMS_METADATA and when you try to generate the DDL for a user using GET_DDL, you will notice the hashed password value is missing, for example, even when user SCOTT has been granted the SELECT_CATALOG role:
SQL> connect scott/tiger
Connected.
SQL> select dbms_metadata.get_ddl('USER','SYSTEM') from dual;
DBMS_METADATA.GET_DDL('USER','SYSTEM')
--------------------------------------------------------------------------------
ALTER USER "SYSTEM"
TEMPORARY TABLESPACE "TEMP"
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |