Category Archives: encryption

Transparant Data Encryption and Oracle Key Vault with Peter Wahl.

Posted on November 1, 2021 by rlockard

I had the pleasure of chatting with Peter Wahl, Oracle Principle Product Manager for Encryption and Secrets. He gives a great talk on Transparent Data Encryption and Oracle Key Vault.

Posted in encryption, infosec, Security | Leave a comment

#Oracle Database Application #Security book is finally out. #infosec #encryption #audit #SecureCoding #PrivilegeAnalysis #OID #OAM #OIM

Posted on November 6, 2019 by rlockard

https://www.amazon.com/Oracle-Database-Application-Security-Directory/dp/1484253663/ref=sr_1_1?keywords=oracle+database+lockard&qid=1573050833&sr=8-1 It’s been a year long process now the book is finally been released. There are a few things I would have written different and a few other subjects I would have liked to cover. Perhaps that will come in … Continue reading →

Posted in Audit, encryption, infosec, PL/SQL, Security, Trusted Path | Tagged , , , , , , , | Leave a comment

Emerging Technology Security Day 2019

Posted on August 20, 2019 by rlockard

Between ongoing data breaches and emerging technologies constantly coming out, you need to ask the question. “Is my information secure?” On October 11th we will be hosting a security day with Oracle Corporation in Reston Virginia. When: October 11, 2019 … Continue reading →

Posted in AI, blockchain, encryption, infosec, Machine Learning, Security, Trusted Path | Comments Off on Emerging Technology Security Day 2019

#Infosec #ManInTheMiddle #encryption passwords sent in clear text

Posted on December 23, 2018 by rlockard

Did you know when you type commands in sqlplus or sqlcl that include a password; if your network is not encrypted, the password is sent in the clear. In fact, all sql commands are sent in the clear to the … Continue reading →

Posted in encryption, infosec | Leave a comment

#POUG2018 is right around the corner.

Posted on August 6, 2018 by rlockard

Let’s start with some key facts. I learned this from my High School Civics teacher who made us learn a bit about journalism along with studying the Constitution.  Who: The Polish Oracle Users Group, hosted by some of the most … Continue reading →

Posted in Database Stuff, encryption, infosec, Oracle Users Group | Tagged , , , , | Leave a comment

You can use #sqlcl with #mkstore

Posted on September 12, 2016 by rlockard

I was struggling last week getting mkstore and sqlcl to work together. sqlcl is Oracle’s new command line interface. For more on sqlcl see http://www.oracle.com/technetwork/issue-archive/2015/15-sep/o55sql-dev-2692807.html. I have been using sqlcl almost exclusively for the past year and love it. I … Continue reading →

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

Four things a DBA can do now to improve their #infosec posture?

Posted on July 9, 2016 by rlockard

August 13, 2018: NOTE UPDATE TO POST THIS IS SPECIFIC TO Oracle 12.1 and bellow. Oracle 12.2 and above, you can change an unencrypted tablespace to an encrypted tablespace. 1) When we start talking about securing information, the first thing that … Continue reading →

Posted in Audit, encryption, infosec, Security, Trusted Path, VPD | Tagged , , , | Leave a comment

Demo code for Ghost Data in Indexes

Posted on May 3, 2016 by rlockard

NOTE: all demo data is fake. This is the demo code for encrypting data where there is an existing index. We are starting with a table customers_tst that is in the unencrypted tablespace dat. start with dropping the old test … Continue reading →

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

#Oracle #TDE Ghost Data Teaser

Posted on August 5, 2015 by rlockard

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

Posted on August 3, 2015 by rlockard

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

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