What can I do if I’ve forgotten my Primavera P6 Professional password?
In this 6 minute video, you learn two options showing how to regain access to your Primavera P6 SQLite password.
Summary of Video Content
If you are running Primavera P6 Professional using the SQLite standalone database, you have basically two options for regaining access if you forgot your password.
Option 1 – Rebuilt your P6 database with a new password
Option 2 – Set your P6 database password to Null
Which of these you choose will depend on how important the data in the database is. If, for example, you just want access to the database for learning or testing purposes (a sandbox) and there was no important schedule data in the existing inaccessible database, then you go with option 1.
If however you have important data in your SQLite database, you will need to recover access to it by setting the encrypted password to Null in the USERS table.
SQL Featured in this video:
update users set passwd = null where user_name = ‘admin’
Copy and paste the above SQL string into your SQLiteSpy tool to set the password to Null.
Another Potential Solution not Featured in the Video
Although not published in the video, it is possible to reset a password in the SQLite database if you have access to a known password in a different SQLite database. You can run a ‘select’ statement on another SQLite database with a known password and then copy the result to your inaccessible database. For example:
select passwd from users
This will return the encrypted string for your known password.
In this example the known password was ‘admin’, so we copied the encrypted string for ‘admin’ into the following SQL statement.
update users set passwd = ‘SHA-256:FBBD91A279DA1028:2710:02F5BDF0E5A0CC2F4F638D8F266CDC354B6480808C0B7B72041940332FEA3DF5’ where user_name = ‘admin’
Running this SQL statement in the SQLiteSpy tool allowed us to regain access to the SQLite database with a password, rather than logging in with a null password.
Again, this is not a recommended approach as there may be issues across different versions of Primavera P6 that were not evident when we tested these solutions. We always recommend managing your passwords carefully and documenting them securely whenever you create new P6 SQLite password for your databases.