Permissions Required to Export Static Reports and Segments to List Manager

When you export a static report or a segment to List Manager, the Report Manager component writes the content to the following tables in the Campaigns database:

lm_master
lm_operations

The account for Report Manager must have Select and Insert permissions on these tables. (By default, Report Manager runs under the local account.)

The List Manager account requires Read permissions on all files that it must import. These permissions are ACLs set on the files.

Important

• The account for the List Manager service must be mapped to the dbo user in the Data Warehouse database. To map a login name to the dbo, in Query Analyzer, run the sp_addrolemember stored procedure as follows:

  Exec sp_addrolemember 'dbo', 'login'
  

  To run the sp_addrolemember stored procedure in Query Analyzer, you must be logged in with "sa" privileges.

  The sp_addrolemember stored procedure will fail if the user has already been added to the Data Warehouse. Do not add the account by using any method other than the sp_addrolemember stored procedure.

  For more information about sp_addrolemenber, see sp_addrolemember in SQL Books Online.

Copyright © 2005 Microsoft Corporation.
All rights reserved.