Data Connection Using Permission

  • Last update:September 22, 2023
  • 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

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy