Siebel Marketing Installation and Administration Guide > Installing and Administering Segmentation and List Generation > Setting Up Marketing Module Parameters in Siebel Analytics >

Verifying Database Privileges for the Marketing Module


The Segmentation and List Generation functions of the Marketing module use write-back capabilities for internal functions such as cache and saved result sets. For security reasons, the administrator can set up a second writable connection pool for the cache and saved result set database whose login and password has database privileges to create tables and write back to the database. Contact your database administrator to verify that the user has these privileges.

To verify that write back has been set up properly

  1. In Target Levels, in Saved Result Sets, verify that the connection pool used for the physical SQL permits writeback.
  2. In Qualified List Items, in Cache Information, verify that the connection pool used for the physical SQL permits writeback.
  3. In User/Group Permissions, for Query Limits for the segmentation database, set Populate Privilege to Allow.

    NOTE:  You do not have to set Populate Privilege to Allow, if you select the Allow populate queries by default check box in the General tab.

Siebel Marketing Installation and Administration Guide Copyright © 2006, Oracle. All rights reserved.