How To Increase The Session Auditing Data Stored In The USESSAUD Table Longer Than The Default Of Five Days (Doc ID 911702.1)

Last updated on MARCH 08, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
All Platforms
***Checked for relevance on 19-Mar-2014***


Goal

This document will provide instruction for increasing the session auditing data stored in the USESSAUD table longer than the default of five days.

For execution of any script below, the following is recommended:
For Oracle:
Log into the instance using SQLPlus or equivalent with the privileged user for the schema (for example: privuser)

For SQL Server 2005 or SQL Express:
Launch SQL Server Management Studio and login with SQL Authentication as PRIVUSER

Solution

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 hundreds of Community platforms