1) It looks like you need dx_set_dbpass. Like all dxtoolkit commands, you can run it across multiple engines.
(dvp21) ranzo.taylor@RanzoTaylorsMBP dxtoolkit2 % ./dx_set_dbpass --help
SYNOPSIS
dx_set_dbpass [ -engine|d <delphix identifier> | -all ] [ -configfile file ][ -group group_name | -dbname db_name | -host host_name | -type dsource|vdb ] [-username <username>] -password <password> [ --help|? ] [ -debug ]
DESCRIPTION
Change user password for a specified database(s)
ARGUMENTS
Delphix Engine selection - if not specified a default host(s) from
dxtools.conf will be used.
-engine|d Specify Delphix Engine name from dxtools.conf file
-all Run script on all engines
-group Group Name
-dbname Database Name
-host Host Name
-type Type (dsource|vdb)
-username user Specify a user
-password pass Specify a password
OPTIONS
-force Skip credential validation. Credentials are verified by update
API for all Oracle objects
-help Print this screen
-debug Turn on debugging
EXAMPLES
Setting new password
dx_set_dbpass -d Landshark5 -dbname "Oracle dsource" -username delphixdb -password newpass
Password has been set.
Trying to set a wrong password
dx_set_dbpass -d Landshark5 -dbname "Oracle dsource" -username delphixdb -password fake
Password check failed.
Username or password is invalid.
2) To solve this problem more generally, Delphix is introducing support for password vaults. Please let us know if Hashicorp or Cyberark would be a useful integration for you regarding database connections?
3) For Oracle specifically, the latest version of Delphix (6.0.7) eliminates the need for a database user. Instead, we use only an OS user. This would also nicely solve your issue!
------------------------------
Ranzo Taylor
Technical Services Director
Delphix
------------------------------
Original Message:
Sent: 03-19-2021 10:06:05 AM
From: Himanshu Sangwan
Subject: How can i change db user password for 60 dataSets- dxtoolkit
Hi I have 60 environments SQL and there is requirement to change DB password in every 90 days so when we try to do it manually it locked the db credentials becuase all my 60 data sets/dsources does a handshake in every 60 sec and pass the number of retries ...which results in locking the password...
Manual solution is .disable environment and data sets and change the password on db first then update the password delphix UI and enable the envioronment.
but this is a ongoing process so i am looking to automate this task via dxtoolkit where i can put all my datset list and it will update the password on one go
any suggestions ?
Thanks
Himanshu
-------