/
Are users allowed to execute SQL updates in Prod

Are users allowed to execute SQL updates in Prod



Description of Issue

Is it ok for sites to run SQL scripts to update data in Prod?



Context

SQL



Cause




Resolution
  • It is a breach of the site's contract with Tyler to change any data by SQL script for Prod since this impacts data integrity and there is not an audit trail.

  • Please contact Support for the relevant module to look into a way of updating data within Enterprise ERP programs instead, if appropriate.



Additional Information












Related content

How to Upgrade Enterprise ERP Version Without Tyler Support Assistance
How to Upgrade Enterprise ERP Version Without Tyler Support Assistance
More like this
How to Refresh Tyler Cashiering Prod to Non-Prod
How to Refresh Tyler Cashiering Prod to Non-Prod
More like this
Scheduled Munis Updates for Tyler Hosted SaaS Clients
Scheduled Munis Updates for Tyler Hosted SaaS Clients
More like this
Enterprise ERP Payroll Service Updating Payroll Tax Tables
Enterprise ERP Payroll Service Updating Payroll Tax Tables
More like this
Permissions do not allow you to update requisitions you have entered
Permissions do not allow you to update requisitions you have entered
More like this
ESS Database refresh between environments
ESS Database refresh between environments
More like this