Tag Archives: oracle

#Oracle #Infosec #Datapump

If you are running a data pump export of your encrypted database and you do not specify encryption or encryption_password then the data will be stored in plain text.  This will give you the ORA-39173 warning.

Posted in Database Stuff, Security | Tagged , , | Leave a comment

#sqldev #outline

Do you spend a lot of time in sql developer working your very large package? Have a look at the quick outline from Jeff Smith of Oracle SQL Developer fame.  Besides being a great Product Manager (hey Uncle Larry, give … Continue reading

Posted in Database Stuff | Tagged , | Leave a comment

#Oracle #TDE Ghost Data Teaser

Here is a teaser for the Oracle Transparent Data Encryption presentation We look at having an existing table with existing indexes. A policy comes out that says we need to encrypt SSN and Credit Card Numbers. Once we encrypt the … Continue reading

Posted in Database Stuff, encryption, infosec, Security | Tagged , , , | Leave a comment

Oracle #OTN #OPSEC #TMTT

Oracle Technology Network Two Minute Tech Tip. Oracle Transparent Data Encryption.

Posted in Database Stuff, encryption, infosec, Security | Tagged , , , | Leave a comment

Oracle Transparent Data Encryption Baseline Practices webinar

I will be giving a webinar on Oracle Transparant Data Encryption Baseline Practices August 27, 2015 at 3PM. Sponsored by @odtug  Why “Baseline Practices?” well best practices does not seem to be working so we are going to start improving … Continue reading

Posted in Database Stuff, Security | Tagged , , , | Leave a comment

#Oracle #TDE #dataleak #Histograms

While at #KSCOPE15, I was asked about encrypted data showing up in histograms.  So, I ran a few experiments and learned that encrypted data does indeed leak. I contacted Oracle through an old friend to get their input. Here is … Continue reading

Posted in Database Stuff, Security | Tagged , , , | Leave a comment

Oracle Transparent Data Encryption Performance. Oracle 12.1.0.2 on Linux 5

  Some performance test on Oracle TDE.  I have three tables t1, t2 and t3. All three tables have identical data and 1.6M rows. I’m going to come back and visit this a bit more later, but want to get … Continue reading

Posted in Database Stuff | Tagged , , , | Leave a comment

#infosec #encrypt backups with #rman

Why should you encrypt your backups? Why should you test your backups? I will be speaking on Holistic Database Security at #kscope15 and #harmony15

Posted in Database Stuff, Security | Tagged , , | Leave a comment

#infosec #Oracle data #redaction

I had a rather disturbing conversion with my wife a couple nights ago, she had called a service provider to discuss a bill.  The customer service rep asked her for her social security number to verify her identity.  When my … Continue reading

Posted in Database Stuff, Security | Tagged , , | Leave a comment

Why does the Oracle cbo interest me so much?

There is a short answer and a very long answer to this.  I will try and keep the answer somewhere in the middle of short and long. The first assumption we must accept and from my observations over the past … Continue reading

Posted in Cost Based Optimizer, Database Stuff | Tagged , | Leave a comment