Resetting Private Database Passwords

Password encryption algorithms are frequently improved in new releases of P6 Professional and P6 Professional. You should reset private database passwords in order to use improved password encryption algorithms.

To reset private database passwords to use the new encryption algorithm:

Go to P6 EPPM <release_level>\database or P6 Professional <release_level>\database.
Run databaselogins.bat (with Windows) databaselogins.sh (with UNIX or Linux).
In the Database Connection dialog box:
1. Select the database.
2. Type the user name and password of a privileged database user (for example, privuser). This login should have administrative rights on the database.
3. Enter the connection details for the database.
  For an Oracle Database, enter the host address, host port, and database/instance name specific to your installation. The Port field displays the default port for the database type you selected.
  
  For an Oracle Autonomous Database, enter the location of the unzipped wallet file and the service name.
  
  For a Microsoft SQL Server Database, enter the host address, host port, and database/instance name specific to your installation. The Port field displays the default port for the database type you selected.
4. Click Next.
In the Private Database Logins dialog box:
1. Select the private database user name that you wish to reset.
2. Highlight the password and change it (or re-enter the existing password).
3. Click Update Password.
4. Click Save.
5. Click OK.

Related Topics