User tables
The permissions in this category control the ability to map, unmap, and manipulate
IBM
®
Campaign
user tables. User tables contain data about customers and prospects for use in flowcharts.
User tables (Administrative permissions)
Permission
Description
Map Base Tables
Allows mapping base tables.
Map Dimension Tables
Allows mapping dimension tables.
Map General Tables
Allows mapping general tables.
Map Delimited Files
Allows mapping user tables to delimited files.
Map Fixed-Width Flat Files
Allows mapping user tables to fixed-width flat files.
Map Database Tables
Allows mapping user tables to database tables.
Remap User Tables
Allows remapping of user tables.
Unmap User Tables
Allows unmapping of user tables.
Recompute Counts and Values
Allows using
Compute
button in table mapping to recompute table counts and values.
Use Raw SQL
Allows the use of raw SQL in Select process queries, custom macros, and dimension hierarchies.
It is strongly recommended that you restrict the ability to use raw SQL to a user who has proper ACL privileges within your organization and disable this functionality from the server side for other users. The ability to use raw SQL in a flowchart process box presents an inherent security risk if not properly managed. Malicious use of raw SQL and stored procedures could impact the availability and security of the system. To reduce the risk of data or privacy loss, administrators are strongly advised to restrict user queries to a set of predefined or precompiled prepared statements and stored procedures. Also, restrict confidential and sensitive data from the user database to the
IBM
®
Campaign
application.
Copyright IBM Corporation 2015. All Rights Reserved.