Month: July 2024
-
How to Remove Orphan Large Objects in PostgreSQL
To manage Binary Large Objects (BLOBS) in PostgreSQL, use the lo_unlink() function to remove them properly. Failing to do so can leave orphaned records, but vacuumlo can help clean them up.
-
Comparing Oracle Users’ Decrypted Passwords with RockYou2024
The “RockYou2024” password leak contains 9,948,575,739 unique plaintext passwords, making it valuable for cybercriminals aiming to perform brute-force attacks. Ensuring the security of Oracle databases is crucial, as weak passwords pose a significant vulnerability. To mitigate this risk, it is recommended to compare database passwords against the 1 million most common ones. A provided SQL script guides this process and demonstrates how to perform the comparison.
Osman’s DBlog 