Websurvey User Can Not Access the Dynamically Created Tables.
Last updated on FEBRUARY 28, 2018
Applies to:Siebel Email Marketing Server - Version 15.11 [IP2015] and later
Information in this document applies to any platform.
Websurvey User Can Not Access The Dynamically Created Tables.
As per the bookshelf, steps for creating WSD user:
1 In the Oracle database, create a new user for the Web Survey Daemon.
2 Assign all Admin privileges to the user, and then log out.
3 Log in as the new user and run the appropriate script for your database (for example, communicatorOracle10g.sql script). This creates all WSD tables.
Using this user in the websurvey.properties does only work partially. It can access his own created tables but it can not access the dynamically created tables which are created in the SIEBEL schema. If you use the SIEBEL user in the websurvey.properties everything works fine.
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