Take the 2-minute tour ×
Information Security Stack Exchange is a question and answer site for Information security professionals. It's 100% free, no registration required.

Are statistical databases vulnerable to SQL injection attacks? If so, what specific kind? Can you think of an example?

share|improve this question
    
Is this homework? The answer may relate to situations where the SQL database is open for aggregation of multiple entries, while selecting a single entry is forbidden. This way, one can collect averages, max values, min values, etc., and this way deduce information of single entries with some probability. –  Henning Klevjer Oct 28 '12 at 7:58
add comment

2 Answers

I might be mincing terms here, but technically no, a statistical database shouldn't be vulnerable to SQL injection, because statistical databases tend not to use SQL as its query language. They tend to use variants of the language like MDX or DMX. Then again, some do support SQL though so...

However, since they do accept input in the form of a language they certainly can be vulnerable to injection because its not really up to the database or its server to prevent injection. Its up to the application calling into the database to properly protect against injection.

There are varying degrees of damage involved here too. In most cases you can't insert data or delete data as these databases/cubes/models tend to be read only, however it could be possible to change the intended result set and get more information than expected. I would expect this to be possible in poorly developed reporting applications.

share|improve this answer
add comment

If by "statistical" you mean "zero inputs" then the answer is: no.

But if this is an SQL DB that accept inputs (i.e. even for filtering purposes) than all standard rules still apply, and its as vulnerable as any other SQL DB.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.