Follow this example to reset your Primavera P6 admin user password using a database query. The same solution applies to reset passwords for any user in Primavera p6. Just replace ‘admin’ with your user_name in the query mentioned in Point 2.
Note: You need the ADMUSER schema access to reset Primavera P6 admin password.
Reset Primavera P6 admin password
1. Log into admuser schema.
2. Use the below SQL to set the password blank. Make sure to do the commit.
update users set passwd = null where user_name = 'admin'; commit;
3. Log in to Primavera P6 with an empty password; No restart required.
4. Change the password after logging in to P6 by click on the Administrator >> User Administration >> Users >> [Select User] >> Change Password.