Successfully!

Error!

Data Connection Using Permission

  • Last update:  2023-09-22
  • Overview

    Version

    Report Server Version

    Functional Change

    11.0

    /

    11.0.7

    Fixed data connection permission problems. For details, see section "Functional Change".

    Application Scenarios

    Data connection using permission refers to a user's permission to use data connection, create template datasets in the designer, and create server datasets in the decision-making platform.

    Example

    Preview

    Implementation Step

    One

    Allow user Alice to use data connection to create template datasets in the designer.

    1. Enable Data Connection Control.

    2. Configure the using permission of the FRDemo data connection.

    3. Configure the remote connection permission.

    Two

    Allow user Alice to use data connection to create server datasets in the decision-making platform.

    1. Enable Hierarchical Authorization and Data Connection Control.

    2. Configure the using permission of the FRDemo data connection.

    3. Configure the using permission of Data Connection   in System Management.

    Example One

    Assign the using permission of the FRDemo data connection to the user Alice, allowing Alice to create template datasets using this data connection in the designer.

    Enabling Data Connection Control

    Log in to the decision-making platform as the super admin, choose System Management > Permission Management > Global Setting, enable Data Connection Control, and click Save.

    Assigning Using Permission to Data Connection

    Log in to the decision-making platform as the admin and choose System Management > Permission Management > Common Permission Configuration.

    You can select the to be assigned target from Dept./Role/User List. In this example, select Alice from User List, and enable the using permission of the FRDemo data connection.

    Assigning Remote Connection Permission

    Connect to the project remotely as the super admin, choose Server > Remote Design Permission Management, and add the user Alice to the list of supporting remote design.

    Demonstration

    Use the designer to remotely connect to the project as Alice. Then Alice can use the FRDemo data connection to create template datasets in the designer.

    Note:

    Non-super admin users cannot perform the following operations in the designer during remote connection to the project:

    1. Create, edit, or delete server datasets.

    2. Enable or disable caching for all datasets.

    3. Create, edit, or delete data connections.

    If an unauthorized data connection is used in the saved/previewed template during remote connection, an error message is displayed in a pop-up box, saying "Saving failed. The current operator lacks x data connection permission(s): XXX".

    Example Two

    Assign the using permission of the FRDemo data connection to the user Alice, allowing Alice to use this data connection to create server datasets in the decision-making platform.

    Enabling Data Connection Control

    Log in to the decision-making system as the super admin, choose System Management > Permission Management > Global Setting, enable Hierarchical Authorization and Data Connection Control, and click Save.

    Assigning Using Permission of Data Connection

    Log in to the decision-making platform as the admin and choose System Management > Permission Management > Common Permission Configuration.

    You can select the to be assigned target from Dept./Role/User List. In this example, select Alice from User List, and enable the using permission of the FRDemo data connection.

    Assigning Using Permission of System Management

    Log in to the decision-making platform as the admin and choose System Management > Permission Management > Common Permission Configuration.

    You can select the to be assigned target from Dept./Role/User List. In this example, select Alice from User List, and enable the using permission of Data Connection in the System Management tab page.

    Demonstration

    Log in to the decision-making platform as the user Alice and choose System Management > Data Connection > Server Dataset. Then Alice can use the FRDemo data connection to create server datasets.

    Functional Change

    FineReport 11.0.7 and Later Versions

    Fixed the problem:

    A user does not have permission to use data connection A and template B uses data connection A. In this case, when the user has editing and design permission of template B, they can open template B and view all data in the data editing window.

    This problem has been fixed in FineReport 11.0.7 and later versions. If the data editing window is opened, the message is displayed, saying "You do not have this data connection permission. Contact the administrator to solve it."

    Note:
    For details about how to assign editing and design permissions of a certain template to a user, see Remote Design.

    Attachment List


    Theme: Decision-making Platform
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback