Hi@Jenifer Metz

 

We have completed the JDBC and MID Server setup successfully and are able to fetch data from the database. However, when we attempt to delete a database user using the SQL statement DROP USER 'f274983', ServiceNow throws the error “Given SQL statement is not allowed to be executed at this time.”

This is expected behavior because ServiceNow JDBC steps block destructive DDL statements such as DROP USER for security reasons. To delete a database user, the supported approach is to use a database side stored procedure and invoke it from ServiceNow via the JDBC step.