Start/Stop Script for MaxDB - How to encrypt the password in the script?

[Former Member]

Hi everyone,

I use a handmade script to stop and start MaxDB instances (inside a larger script witch start/stop the whole SAP system).

My problem is that I have to store the password of the dbuser blank in the script.

Like -u Control, control (User, PASSWORD).

Is there a possibility to store a encrypted passsword in a way the database is able to decrypt automatically (MD5)?

[markus_doehr2 · Accepted solution]

as use <sid>adm you can always user

dbmcli -U c (capital 'U' and 'c' for control user)

You can add more users using the tool

xuser

xuser list

will list all the aliases defined.

--

Markus

[Former Member · Accepted solution]

Hallo,

it seems to me that if I use this option in the script, there is no valid password stored but isn`t it similarly unsafe to store the xuser key unecrypted??

[TTK · Accepted solution]

Hello

In general you are right regarding storing the password in xuser. However a crucial difference is, that the password is not visible in the process list of the machine, which is the case, if it is in the calling arguments of the process.

Regards Thomas

[Former Member · Accepted solution]

Hallo,

and what is more: xuser data is only accessible for the OS user who owns them! So if a different OS user checks the process list of the machine, the information that he gets from there does not help him!

Regards Marc-Philip

[Former Member]

Hi Thomas,

check out the XUSER tool in the MaxDB documentation.

HTH,

Marc-Philip