Issues using multiple writers with IQ Loader DB via Insert Location component

[CR #560036] To use the multiple writers, you must have execute permission on the sp_iqtable and sp_iqcolumn stored procedure privilege in the target IQ database, as well as the appropriate permissions on create table and execute sp_iqstatistics.

Workaround: Set the required permission using Sybase Central™:

  1. In Sybase Central, connect to the Sybase IQ 15.0 server as DBA user or a member of dbo role.

  2. Expand Users & Groups, then select the user or group for whom you want to set the permission.

  3. Right-click the user or group and select Properties.

  4. Select the Permissions tab, then select Procedures & Functions to see a list of all the available permissions.

  5. Select sp_iqtable and sp_iqcolumn, then click the corresponding Execute column to grant the user permission to execute the stored procedure in the IQ database.

  6. Click OK to save the settings.