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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms