Skip to content Skip to main content
GoldMine CRM

GoldMine : Lock down your SQL queries with GoldMine 2019

By November 22, 2019No Comments

Those GoldMine geeks amongst us have known about this security hole for years: the SQL Query tool in GoldMine. Thankfully, it only works with SELECT statements. That being said, there was nothing stopping a disgruntled salesman from “SELECTing * from CONTACT1” and walking away with your client list.

Until now. You can disable SQL Querying at the database alias level.

Go to Tools | Databases | Alias Manager | Edit Alias

Uncheck “Enable SQL Queries” and Ok your way out.

All users will need to restart their GoldMine to get the change.

Justin Hill

Author Justin Hill

More posts by Justin Hill

Leave a Reply