I need to execute a delete or truncate command, i have permissions in the DB to delete and truncate with the user that is connected on the database connections, if i go to sql server i can delete the table using delete from tbl_XXX and it runs correctly, but when trying to run it from qvera using
var queryResult = qie.doQuery("DBTest", "delete from tbl_BarDataPaymentsRefunds;");
I get this error:
[line: 2] [func: 1 line: 1] NoResultsException: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE permission was denied on the object 'tbl_XXX', database 'XXXXX', schema 'dbo'.
Query: delete from tbl_XXX; in <Unknown Source> at line number 2
Does the qie.doQuery run delete / truncate commands?