How to hide oracle database account password in create user sql script
Hi Mark,
My name is Joy.
I have a question which is related to this thread.
We run oracle database on Linux and use shell/sql scripts to build our databases. Given that we presently support 12.1, 12.2, 19.5.
One challenge we are facing is:
How to avoid password in clear text in our scripts?
Note -- this is not about shell script that is executed via oracle cron scheduler on a regular basis.
Example:
cr_schema_users.sql -- we store all application schema user creation DDL in this script and run it when we build/refresh databases. And of course, create user xxx identified by xxx; is hard coded in the script.