Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_metadata.get_ddl to get user ddl

GunaSep 8 2016 — edited Sep 10 2016

I am trying to get user ddl with encrypted password using dbms_metadata.get_ddl but the DDL comes out without the password (IDENTIFIED BY VALUES) clause. I tried granting dba and create user privilege to the user that i am executing this function but still the ddl comes out without password. Is this a privilege issue? If so, could someone let me know what privilege am i missing? Thanks in advance.

Thanks,

Guna
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2016
Added on Sep 8 2016
#database-security, #database-security-general
7 comments
19,888 views