My Oracle Support Banner

How to Resync the 'privuser' and 'pubuser' P6 Database users (Doc ID 900443.1)

Last updated on MAY 25, 2021

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 and later
Primavera P6 Professional Project Management - Version 6.2.1 and later
All Platforms


This document provides steps to "resync" the privuser and pubuser schema users for a P6 database hosted on SQL Server. 

After restoring or attaching a P6 database, the privileged and public accounts associated with the SQL Server instance must be resynchronized with the corresponding users associated with the P6 database.  Neglecting this step will prevent the P6 application from being able to connect successfully to the database.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.