Editing Database Files Directly - Validation - Forum - OpenEdge RDBMS - Progress Community

Editing Database Files Directly - Validation

 Forum

Editing Database Files Directly - Validation

This question is answered

One of our developers asked what happens if someone uses notepad or notepad++ or some other text editing tool to edit data in the database extents directly. 

We tried it on a throw away database and as expected we saw errors like wrong dbkey and other system errors that would shut down the db server.  Are there cases were editing the DB files using a text editor or hex editor would not result in block corruption?  I'm talking about simple edits where that a novice user would attempt and not a tech savvy user/progress database engineer. 

Verified Answer
  • > One of our developers asked what happens if someone uses notepad or notepad++ or some other text editing tool to edit data in the database extents directly.

    What happens, in all likelihood, is that they corrupt the database beyond repair, in ways that you may or may not notice until it's too late.  I'd be wondering about the motivations of the developer, or whoever else might be thinking along these lines.  

    > I'm talking about simple edits where that a novice user would attempt and not a tech savvy user/progress database engineer.

    If you want to do simple edits to data, write a simple ABL procedure and run it.  "Novice users" who think otherwise should be re-educated or have their system access removed.

  • Blocks in type 2 storage areas are protected by CRCs: changing just a bit inside a database block will be detected .

All Replies
  • The audit data does include a hash to ensure it has not been tampered with.

    The addition of TDE would be an additional layer to the security onion since it will prevent reading the data from disk as well.

    Just FYI, the block CRCs are not there for security - they are there to help identify data corruption.

  • > On Apr 5, 2019, at 12:40 PM, George Potemkin wrote:

    >

    > Adding a sewing kit to a knife and is still not enough to become a surgeon. ;-)

    >

    >

    >

    true. but i am a rocket surgeon. :)