User tables

The permissions in this category control the ability to map, unmap, and manipulate Unica Campaign user tables. User tables contain data about customers and prospects for use in flowcharts.

Table 1. 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 Unica Campaign application.