Some of the people I spoke with after the show did not understand how this could be the case, but unless you are looking at the log files to detect this type of system event, it will go entirely unnoticed. User access, DBA roles, and multifactor authentication requirements simply vanish.
My interest in pointing this out is not the novelty of the attack, but rather to point out that you probably have tools in your house to detect or even prevent this type of exploit. The presentation lacked some of the detection and prevention tactics, so I will mention a few here:
1. Every commercial database vulnerability assessment scanner on the market checks for the exploits mentioned above. New variations may be found, but most of the avenues for exploitation can be checked and verified fixed.
2. This is why constantly checking for patches and keeping current is so important -- two of the three attacks could be thwarted with current patches.
3. Injection attacks launch code with the same privileges that the database runs under, so it's not like access controls are going to help with that. 4. Stored procedures, external or internal, are a handy tool for administrators. And they are really dangerous. They remain a principle avenue for exploit, so external stored procedures should be disabled and changes to internal procedures carefully monitored.
5. File-permissions monitoring, either through assessment, database assessment, or file monitoring tools, will detect the attack.
6. Permissions monitoring is a pain in the -- well, you know. But checking stored procedure settings and user access maps to stored procedures is necessary. There are commercial tools to automate, or you can write some simple scripts to detect, but make sure this is in your arsenal.
If you are not sure your policies cover this threat, then go check.
Adrian Lane is an analyst/CTO with Securosis LLC, an independent security consulting practice. Special to Dark Reading.
| To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy. |