My Oracle Support Banner

EPM 9.1: OWS_USER Requires Truncate Privileges (Doc ID 1928399.1)

Last updated on JUNE 26, 2018

Applies to:

PeopleSoft Enterprise EPM HCM Warehouse - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


Customer has some reservation to grant such privilege and their DBA is asking, you are indicated that the OWS_USER requires truncate privileges. The only way is to grant truncate any table privilege and there is concern giving that much privileges to a user. Customer suggested a few work-around such as creating an procedure to truncate that table only and granting execute privileges to the OWS_USER. Another work-around was to create a before insert - database trigger. Another work-around is modify the delivered job using the tab 'BEFORE' to call the stored procedure to truncate the table. Finally create a custom job that will allow the truncate of the table. Can you please verify if there is a current workaround other users are using to truncate other then to give truncate any table.


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.