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

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