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

[Ashok]

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.

[MikeG]

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:

And here:

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

[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?

[MikeG]

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