Changing Portal Database User Ids

The recommended way to change the users through which Portal accesses the database, is to change the user names in the Portal properties file and run the connect-database task. This updates the datasources while maintaining current properties in the Portal configuration files, so that the values are correct when running configuration tasks at a later date.

Portal 6.0:

1. For a cluster, start the deployment manager and node agent if they are not already running.
2. Stop Portal
3. Edit the following file:
   PortalServer/config/wpconfig_dbdomain.properties
   Update the properties file with the new user id and password for each domain:
   dbdomain.dbUser=newDBUser
4. Navigate to the following directory:
   PortalServer/config/
5. Start the connect-database task:
   Windows:
   WPConfig.bat connect-database
   AIX, Solaris, Linux, Unix:
   ./WPConfig.sh connect-database
6. Once the configuration task has completed successfully, start Portal

1. For a cluster, start the deployment manager and node agent if they are not already running.
2. Stop Portal
3. Edit the following file:
   <portal profile>/ConfigEngine/properties/wkplc_comp.properties
   Update the properties file with the new user id and password for each domain:
   
   dbdomain.dbUser=newDBUser
4. Navigate to the following directory:
   <portal profile>/ConfigEngine/
5. Start the connect-database task:
   ./ConfigEngine.sh connect-database
6. Once the configuration task has completed successfully, start Portal

Alternatively, you can change the datasources in the WebSphere Application Server (WAS) administrative console:

1. In the WAS admin console, or, in a cluster, the the deployment manager console, navigate to J2C authentication data:
   WebSphere Application Server 6.0:
   Secure administration, applications, and infrastructure > JAAS - J2C authentication data
   WebSphere Application Server 6.1:
   Security > Secure administration, applications, and infrastructure > Java Authentication and Authorization Service > J2C Authentication Data
   WebSphere Application Server Version 7.0:
   Security > Global security > Java Authentication and Authorization Service > J2C Authentication Data.
2. For each Portal database alias, (for example, you might see wpsDBAuth, wmmDBAuth, jcrDBAuth, fbkDBAuth, lmDBAuth, and wcmDBAuth)
   1. Click to navigate to the configuration pane, where you will see the User ID and password fields.
   2. Change the user id to the desired db2 user.
   3. Make sure the password is correct.
   4. Click OK and save the changes. You will get a message saying that security.xml has been updated.
3. Restart the application server or deployment manager.
   
4. Ensure that the wpconfig_dbdomain.properties file for Portal v6.0 and the wkplc_comp.properties file for Portal v6.1 are updated with the new databse user IDs.