Changing a Database User Password (KBA1115)

How to Change a DB User Password using the GUI 

1. Log into the Delphix Admin App.
2. Select the dSource card for which you would like to change the Database Username or Password.
3. Click on the Pencil icon next to DB User to Edit.
4. Change Username and or Password and click Verify Credentials.
5. Once verified, select the Check Mark on the lower right to save changes.

How to Change a DB User Password using the CLI 

1. ssh into your engine using Admin privileges

ssh delphix_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 *> credentials.password=<new password>

4. Commit the change

delphix sourceconfig "database" update *> commit

Example:

ssh delphix_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 *> credentials.password=<new password>
delphix sourceconfig "meta1" update *> commit