CLI Cookbook: How to Change Database User Password
Reference / Command Line Interface Guide / CLI Cookbook: Common Workflows, Tasks, and Examples / CLI Cookbook: Source Databases and dSources / CLI Cookbook: How to Change Database User Password

1. ssh into your engine using Admin privileges.

ssh admin@delphixengine

2. Go to sourceconfig and fine the Database that you need to update the password on.

delphix > sourceconfig
delphix sourceconfig > ls
delphix sourceconfig > select <yourdatabase>
 

3. Update the password.

delphix sourceconfig "yourdatabase" > update
delphix sourceconfig "yourdatabase" update *> ls
delphix sourceconfig "yourdatabase" update *> set credentials.password=<new password>

4. Commit the change.

delphix sourceconfig "database" update *> commit

Example:

ssh admin@example
delphix > sourceconfig
delphix sourceconfig > ls
 
Objects

NAME   REPOSITORY                  LINKINGENABLED
meta1  '/u01/oracle/10.2.0.4/ee1'  true

Operations
create

delphix sourceconfig > select meta1
delphix sourceconfig "meta1" > ls
 
Properties
    type: OracleSIConfig
    name: meta1
    credentials:
        type: PasswordCredential
        password: ********
    databaseName: meta1
    discovered: true
    environmentUser: delphix
    instance:
        type: OracleInstance
        instanceName: meta1
        instanceNumber: 1
    linkingEnabled: true
    nonSysCredentials: (unset)
    nonSysUser: (unset)
    reference: ORACLE_SINGLE_CONFIG-1
    repository: '/u01/oracle/10.2.0.4/ee1'
    services:
        0:
            type: OracleService
            discovered: true
            jdbcConnectionString: jdbc:oracle:thin:@172.16.100.69:1525:meta1
        1:
            type: OracleService
            discovered: true
            jdbcConnectionString: jdbc:oracle:thin:@172.16.100.69:1521:meta1
    uniqueName: meta1
    user: delphix

Operations
delete
update
validateCredentials

delphix sourceconfig "meta1" > update
delphix sourceconfig "meta1" update *> set credentials.password=<new password>
delphix sourceconfig "meta1" update *> commit