How to reset your forgotten Primavera P6 user password using database query
Follow this example to reset your Primavera P6 admin user password using a database query. The same solution applies to reset 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';
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
The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.
Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
Latest posts by Govind
- JSF Login Logout Form Authentication Example - October 16, 2017
- How to Bookmark URL in JSF using GET method and ViewParam – example - October 14, 2017
- JSF Dynamic Navigation and how to use wildcard in navigation - October 12, 2017