Skip to main content
A
Ashok
Contributor
June 8, 2023
Solved

SQL Editor - How to enable access to end user to allow them to Insert/Delete/Save in the SQL table

  • June 8, 2023
  • 2 replies
  • 1 view

 

Hello Experts,

I have simple SQL editor component in a DB. as Admins we can use the toolbar to Insert/Delete/Save in the SQL table behind the scene. for end users it is disabled is there any other setting that needs to turned on? Appreciate the help.

Ashok_2-1686246679560.png

 

 

    Best answer by Ashok

    Thanks Mike. Earlier we were getting SQL access error so we got AccessGroupforAncillaryTables changed to Everyone and it worked fine to view the data. Not sure what "MaintenanceGroupAncillaryTables"  does should change that as well to Everyone?

    2 replies

    MikeG
    MikeG
    Contributor
    June 8, 2023

    There are properties - server side - that need to be set in the XFAppServerConfig file to permit users to access/edit the Ancillary tables.  By default - out-of-box - these settings here are set to Administrator.  If your client is Cloud Hosted, it requires a Support Ticket to OS Cloud team.

    These here:

    MikeG_0-1686247120170.png

    And here:

    MikeG_1-1686247148261.png

    You can check through the Desktop Application by going to System > Environment > and click on one of the Application Server Sets.

     

    Hope this helps,

    Mike G

    Archetype Consulting

     

     

     

      A
      AshokAuthorAnswer
      Contributor
      June 8, 2023

      Thanks Mike. Earlier we were getting SQL access error so we got AccessGroupforAncillaryTables changed to Everyone and it worked fine to view the data. Not sure what "MaintenanceGroupAncillaryTables"  does should change that as well to Everyone?

        MikeG
        MikeG
        Contributor
        June 9, 2023

        The Maintenance Group is EDIT access to the ancillary tables, ability to INSERT and SAVE records.  The Access Group is READ access to the ancillary tables.  Instead of using the default group EVERYONE, create a Security Group for managing Read and Write to those tables.  I don't think in the long term you will want Everyone to be able to Edit.

        1) Create the Groups in the Security Framework

        2) Assign those Groups in the XFAppConfig file

        3) Assign users to the Read and Write groups respectfully

        MikeG_0-1686315357598.png

         

        That is your long term solution so you don't need to revisit or rebuild security later down the road.

        Best regards,

        Mike G

          Terms & ConditionsAccessibility statement