ReportAdvanced.sql Script

The ReportAdvanced.sql script is located in the \Program Files\Microsoft Commerce Server\Support folder.

The ReportAdvanced.sql script creates the ReportAdvanced database role. The ReportAdvanced role inherits all of the permissions granted to the ReportViewer role.

The ReportAdvanced.sql script grants the ReportAdvanced role permissions on the tables in the Data Warehouse SQL Server database so that Business Desk users can do the following:

• Create new dynamic reports
• Delete custom reports
• Modify existing reports

The ReportAdvanced.sql script grants the ReportAdvanced role the following permissions on the specified Data Warehouse tables:

Data Warehouse table	Permission
Report	Insert Update Delete
ReportDimension	Delete
ReportParam	Delete
ReportStatus	Delete
GroupReportJob	Delete
GroupReportStatus	Delete
GroupReportDbObject	Delete

Copyright © 2005 Microsoft Corporation.
All rights reserved.