Websurvey User Can Not Access the Dynamically Created Tables. (Doc ID 2303459.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel Email Marketing Server - Version 15.11 [IP2015] and later
Information in this document applies to any platform.

Symptoms

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.

Cause

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