# US 2012/0259839 A1 · Firewalls for securing customer data in a multi-tenant environment

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

- Number: US 2012/0259839 A1
- Document ID: US20120259839A1
- Status: Published application
- Kind: A1
- Application number: 13/528,744
- Filed: 2012-06-20
- Published: 2012-10-11
- Earliest claimed: 2005-12-02
- Assignees: salesforce.com, inc.
- Inventors: Eric Chan; Craig Weissman; Paul Nakada; Dave Moellenhoff; Todd McKinnon
- Web page: https://patentgrep.com/patent/US20120259839A1

## CPC

- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- G06F 16/2455: Query execution
- G06F 16/24575: {using context}
- G06F 21/554: {involving event detection and direct action}
- H04L 63/1441: {Countermeasures against malicious traffic (countermeasures against attacks on cryptographic mechanisms H04L9/002)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Network security is enhanced in a multi-tenant database network environment using a query plan detection module to continually poll the database system to locate and raise an alert for suspect query plans. Security also can be enhanced using a firewall system sitting between the application servers and the client systems that records user and organization information for each client request received, compares this with information included in a response from an application server, and verifies that the response is being sent to the appropriate user. Security also can be enhanced using a client-side firewall system with logic executing on the client system that verifies whether a response from an application server is being sent to the appropriate user system by comparing user and organization id information stored at the client with similar information in the response.

## Claims

### Claim 1

A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to implement a method, the method comprising:
storing data for each of multiple tenants in a database system;
providing network access to the database system for each of the multiple tenants by an application server, wherein the application server is communicably coupled to the database system and to a network;
polling the database system for query plans by a query plan detection module;
analyzing the query plans by the query plan detection module; and
determining by the query plan detection module whether at least one of the query plans is suspect.

### Claim 2 (depends on 1)

The computer program product of claim 1, wherein the query plan detection module prevents execution of a suspect query plan.

### Claim 3 (depends on 1)

The computer program product of claim 1, wherein the query plan detection module generates an alert if the at least one of the query plans is suspect.

### Claim 4 (depends on 1)

The computer program product of claim 1, wherein for each suspect query plan, the query plan detection module determines whether the suspect query plan falls under a query plan exception.

### Claim 5 (depends on 4)

The computer program product of claim 4, wherein a suspect query plan falling under a query plan exception is executed.

### Claim 6 (depends on 1)

The computer program product of claim 1, wherein the query plan detection module logs query plan information if the at least one of the query plans is suspect.

### Claim 7 (depends on 1)

The computer program product of claim 1, wherein the query plan detection module runs during production and development.

### Claim 8 (depends on 1)

The computer program product of claim 1, wherein the query plans are analyzed to determine whether the at least one of the query plans is suspect by determining whether the at least one of the query plans is at least one of: a query plan that should never occur in a multi-tenant database system or a query plan that should only occur in a small number of identified circumstances in a multi-tenant database system.

### Claim 9

A multi-tenant database system, comprising:
a processor; and
one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of:
storing data for each of multiple tenants in a database system;
providing network access to the database system for each of the multiple tenants by an application server, wherein the application server is communicably coupled to the database system and to a network;
polling the database system for query plans by a query plan detection module;
analyzing the query plans by the query plan detection module; and
determining by the query plan detection module whether at least one of the query plans is suspect.

### Claim 10

A method, comprising:
storing data for each of multiple tenants in a database system;
providing network access to the database system for each of the multiple tenants by an application server, wherein the application server is communicably coupled to the database system and to a network;
polling the database system for query plans by a query plan detection module;
analyzing the query plans by the query plan detection module; and
determining by the query plan detection module whether at least one of the query plans is suspect.
