DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 14, 2016

Oracle Database 12C release 1 (12.1)-ENCRYPTION_PWD_PROMPT=Y

There is new option to pass in silent mode encryption password in Oracle 12C during exporting sensitive data. In new version user is asked about password during execution of export.

expdp ... ENCRYPTION_PWD_PROMPT=Y ...

Password: <user is asked for encryption password>
In previous version encryption password was explicit passed to expdp using parameter ENCRYPTION_PASSWORD. So could be visible via ps command or in a expdp parameter script.

Features:

new parameter ENCRPTION_PWD_PROMPT as default set to N
if the parameter is set to Y then user is asked for encryption password during export
the password is not visible via commands like PS nor stored in scripts
old 11g ENCRYPTION_PASSWORD and ENCRYPTION_PWD_PROMPT=Y can’t be used in the same time and generate an error

No comments: