Can you run a SQL delete statement through the GoldMine SQL Query feature?
1. Tools >> SQL Query
>> Can you run a SQL delete, insert or update statements through this GoldMine interface? Is there anyway to let users only execute Select statements?
- Via the Tools >> SQL Query feature within GoldMine ONLY Select statements can be submitted, any other attempts of deleting, updating or inserting data via this pane is not possible and the Query button will remain grayed out
- This is by intention of GoldMine so that no data can be modified via SQL statements by any user
- Any data should be changed by the user via the GoldMine User Interface in the specific area e.g. on the Contact Record, via Global Replace, by Editing activities etc.
- Also other areas within GoldMine where SQL queries are involved , for example Dashboards will not allow any modification statements but instead only Select statements.