CLI cookbook: how to change database user password

ssh into your engine using Admin privileges.
CODE
```
ssh admin@delphixengine
```

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

CODE

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

Update the password.

CODE

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

Commit the change.

CODE

delphix sourceconfig "database" update *> commit

Example:

CODE

ssh admin@exampledelphix > 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