Database Administration (MOSC)

MOSC Banner

How to hide oracle database account password in create user sql script

edited Jan 10, 2020 1:42PM in Database Administration (MOSC) 39 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center