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

Last updated on MARCH 16, 2016

Applies to:

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

Goal

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.
 

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