Sometimes we need changing admin password of Oracle Primavera P6.
Customers can forget admin password of Primavera P6 EPPM. So we should reset admin password of EPPM like following.
Connect to database with admuser and execute following query.
update users set passwd = 'Deveci2019' where user_name = 'admin';
[oracle@MehmetSalih ~]$ sqlplus admuser/admuser SQL*Plus: Release 18.104.22.168.0 Production on Tue Mar 19 11:01:19 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production SQL> update users set passwd = 'Deveci2019' where user_name = 'admin'; commit;
You can change admin password from Primavera P6 EPPM web interface like following.
You can change EPPM Admin password from webconsole ( Administration—>User Administration—>Right Click Admin User—> Change Password—> Specify New Password)
If you want to change other EPPM database users, you can use following query.
alter user ADMUSER identified by Deveci2019; alter user PRIVUSER identified by Deveci2019; alter user BGJOBUSER identified by Deveci2019; alter user PUBUSER identified by Deveci2019;