Skip to main content

SQL Ingection for Geotab Ace Feature

VMava-2063
Original Poster

I can see tables and data by running SQL queries. How do you prevent system for SQL Injection?

 

Also I would like to know how it can help customer to get most out of it.

 

I asked "Give me 10 asset inspections recently created." it was giving Fault code data.

Join the conversation

You need to be logged in to reply to this post and participate in the Geotab Community discussions.

Top Answers

Thanks for your question.

Geotab Ace's query execution is read-only which eliminates the possibility of any modifications on the database.

There are a number of safegaurds in place. Please refer to this document: https://www.geotab.com/CMS-GeneralFiles-production/data/Geotab%20Ace%20-%20Responsible%20AI%20Whitepaper%20[PUB]%202024.pdf

 

Ace currently does not support asset inspections data. If it is however set as a rule you can use the @ feature to search for the exception and get the results.

 

For a quick session on Ace view this video:

https://drive.google.com/file/d/14LaZhXNdysX71UYcug569GXN895kbolS/view?usp=sharing

 

User Guide

Prompt Guide

 

If you need further training please don't hesitate to reach out to me directly: sajadshiravi@geotab.com

 

1 Reply

Thanks for your question.

Geotab Ace's query execution is read-only which eliminates the possibility of any modifications on the database.

There are a number of safegaurds in place. Please refer to this document: https://www.geotab.com/CMS-GeneralFiles-production/data/Geotab%20Ace%20-%20Responsible%20AI%20Whitepaper%20[PUB]%202024.pdf

 

Ace currently does not support asset inspections data. If it is however set as a rule you can use the @ feature to search for the exception and get the results.

 

For a quick session on Ace view this video:

https://drive.google.com/file/d/14LaZhXNdysX71UYcug569GXN895kbolS/view?usp=sharing

 

User Guide

Prompt Guide

 

If you need further training please don't hesitate to reach out to me directly: sajadshiravi@geotab.com

 

Still have questions?