Restore Portal Export Privileges in ICA 6.5.4

book

Article ID: 198879

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

Three new portal privileges were added in ICA 6.5.4 to control export functions:

  • Can Export
  • Can Export Dashboard
  • Can Schedule Exports

These privileges are disabled by default, causing all portal users who previously had the ability to export to no longer be able to do so.

Resolution

To re-enable export privileges for all portal users who had these privileges prior to upgrading ICA to version 6.5.4, do the following:
  1. Open SQL Server Management Studio (SSMS).
  2. In the Connect to Server window, from the Server type drop-down menu, select Database Engine.
  3. Enter the server name and credentials for the server hosting the Risk Fabric database and click Connect.
  4. From the File menu, select Open > File...
  5. Locate and open the file RF-20455_1599271947036.sql (attached to this article)
  6. Confirm the Risk Fabric database is selected in the drop-down menu to the left of the Execute button on the SQL Editor toolbar (note that the database name may differ in your environment).
  7. Execute the script by pressing the function key F5, clicking the Execute button in the SSMS toolbar, or selecting Execute from the Query menu.

Additional Information

PortalPermissionValueIDs: 73, 74, 75

Attachments

RF-20455_1599271947036.sql get_app