# US 2023/0067054 A1 · Encryption of database log files

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2023/0067054 A1
- Document ID: US20230067054A1
- Status: Published application
- Kind: A1
- Application number: 17/445,744
- Filed: 2021-08-24
- Published: 2023-03-02
- Earliest claimed: 2021-08-24
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Vaibhav Murlidhar Kulkarni; Sweta Singh; MARIO BRIGGS
- Web page: https://patentgrep.com/patent/US20230067054A1

## CPC

- H04L 9/0841: {involving Diffie-Hellman or related key agreement protocols}
- H04L 9/088: {Usage controlling of secret information, e.g. techniques for restricting cryptographic keys to pre-authorized uses, different access levels, validity of crypto-period, different key- or password length, or different strong and weak cryptographic algorithms (network architectures or network communication protocols for using time-dependent keys in a packet data network H04L63/068)}
- H04L 9/0894: {Escrow, recovery or storing of secret information, e.g. secret key escrow or cryptographic key storage}
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Provided is a method for method for encrypting log file data in a multitenant database. The method comprises receiving a request to secure data of a tenant in a multitenant database. The method further comprises obtaining a symmetric encryption key that is specific to the tenant. The method further comprises encrypting data of the tenant using the symmetric encryption key. The data that is encrypted is stored in the multitenant database. The method further comprises encrypting a set of log file entries using the symmetric encryption key. The set of log file entries are associated with data of the tenant.

## Claims

### Claim 1

A method comprising:
receiving a request to secure data of a tenant in a multitenant database;
obtaining a symmetric encryption key that is specific to the tenant;
encrypting data of the tenant that is stored in the multitenant database using the symmetric encryption key; and
encrypting a set of log file entries using the symmetric encryption key, wherein the set of log file entries are associated with data of the tenant.

### Claim 2 (depends on 1)

The method of claim 1, wherein the request to secure the data of the tenant is received during an initial registration of the tenant.

### Claim 3 (depends on 1)

The method of claim 1, wherein obtaining the symmetric encryption key that is specific to the tenant comprises generating the symmetric key by performing a Diffie-Hellman key exchange operation to generate the symmetric encryption key.

### Claim 4 (depends on 3)

The method of claim 3, wherein the Diffie-Hellman key exchange operation is performed by an automated process of a cloud service and by the tenant.

### Claim 5 (depends on 1)

The method of claim 1, further comprising storing the symmetric key in a secure area of the multitenant database, wherein the secure area is not accessible by a database operator.

### Claim 6 (depends on 5)

The method of claim 5, wherein the secure area includes symmetric keys for a plurality of tenants, each of the plurality of tenants having data in the multitenant database.

### Claim 7 (depends on 1)

The method of claim 1, wherein each tenant of the multitenant database has its own symmetric key, and wherein each log file entry of the set of log file entries is encrypted using the symmetric key of the tenant associated with the log file entry.

### Claim 8

A system comprising:
a memory; and
a processor communicatively coupled to the memory, wherein the processor is configured to perform a method comprising:
receiving a query against a multitenant database, wherein the query is associated with data for a first tenant of a plurality of tenants having data in the multitenant database;
identifying a first symmetric key, wherein the first symmetric key is associated with the first tenant;
processing the query;
generating, based on the query, a first log record;
encrypting the first log record using the first symmetric key; and
storing the first log record in a transaction log for the multitenant database.

### Claim 9 (depends on 8)

The system of claim 8, wherein each tenant of the multitenant database has its own symmetric key, and wherein each log record in the transaction log is encrypted using the symmetric key of the tenant associated with the log record.

### Claim 10 (depends on 8)

The system of claim 8, wherein identifying the first symmetric key comprises:
determining a tenant ID the first tenant; and
retrieving, from a secure area of the memory, the first symmetric key using the tenant ID of the first tenant.

### Claim 11 (depends on 10)

The system of claim 10, wherein the secure area is not accessible by a database operator.

### Claim 12 (depends on 10)

The system of claim 10, wherein the secure area includes symmetric keys for each of the plurality of tenants.

### Claim 13 (depends on 8)

The system of claim 8, wherein the first log record includes the query and one or more other fields, and wherein encrypting the first log record includes encrypting at least the query.

### Claim 14 (depends on 8)

The system of claim 8, wherein each tenant of the multitenant database has its own symmetric key, and wherein each log record in the transaction log is encrypted using the symmetric key of the tenant associated with the log record.

### Claim 15

A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to perform a method comprising:
receiving a request to secure data of a tenant in a multitenant database;
obtaining a symmetric encryption key that is specific to the tenant;
encrypting data of the tenant that is stored in the multitenant database using the symmetric encryption key; and
encrypting a set of log file entries using the symmetric encryption key, wherein the set of log file entries are associated with data of the tenant.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein the request to secure the data of the tenant is received during an initial registration of the tenant.

### Claim 17 (depends on 15)

The computer program product of claim 15, wherein obtaining the symmetric encryption key that is specific to the tenant comprises generating the symmetric key by performing a Diffie-Hellman key exchange operation to generate the symmetric encryption key.

### Claim 18 (depends on 17)

The computer program product of claim 17, wherein the Diffie-Hellman key exchange operation is performed by an automated process of a cloud service and by the tenant.

### Claim 19 (depends on 15)

The computer program product of claim 15, wherein the method further comprises storing the symmetric key in a secure area of the multitenant database, wherein the secure area is not accessible by a database operator.

### Claim 20 (depends on 19)

The computer program product of claim 19, wherein the secure area includes symmetric keys for a plurality of tenants, each of the plurality of tenants having data in the multitenant database.
