Forum Discussion

Ashok's avatar
Ashok
New Contributor III
3 years ago
Solved

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

  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 othe...
Dashboards
  • Ashok's avatar
    Ashok
    3 years ago

    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's avatar
MikeG
Contributor III
3 years ago

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

 

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

Best regards,

Mike G