My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

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

Goal

This document provides steps to "resync" the privuser, pubuser and pxrptuser 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.

Solution

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

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

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