# US 2009/0157687 A1 · Team based row level security system and method

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

- Number: US 2009/0157687 A1
- Document ID: US20090157687A1
- Status: Published application
- Kind: A1
- Application number: 12/166,256
- Filed: 2008-07-01
- Published: 2009-06-18
- Earliest claimed: 2004-10-22
- Assignees: SugarCRM Inc.
- Inventors: Jacob Taylor; Clinton Oram; John Roberts
- Web page: https://patentgrep.com/patent/US20090157687A1

## CPC

- G06F 21/6218: {to a system of files or objects, e.g. local or distributed file system or database}
- G06F 2221/2141: Access rights, e.g. capability lists, access control lists, access tables, access matrices
- G06F 2221/2145: Inheriting rights or properties, e.g., propagation of permissions or restrictions within a hierarchy
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A team based row level security system and method are provided that permits items of data to be shared across a team.

## Claims

### Claim 1

An apparatus for controlling access to an item, comprising:
a computer system that executes a data access system that comprises a plurality of computer instructions to implement the data access system;
the data access system having a data store containing a plurality of data items and a team membership record associated with each data item, a team hierarchy assigned to each data item and a security module that comprises a plurality of computer instructions to implement security of the plurality of data items; and
wherein the security module further comprising computer instructions that modify the team membership record to assign a member to the team hierarchy assigned to a particular data item wherein the team hierarchy includes one or more of an explicit team member for a member explicitly assigned to the team hierarchy for the particular data item and an implicit team member that identifies a second member that has an explicit team member who reports to the second member.

### Claim 2 (depends on 1)

The apparatus of claim 1, wherein the security module further comprises computer instructions that automatically creates an implicit team membership for a member based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 3 (depends on 1)

The apparatus of claim 1, wherein the security module further comprises computer instructions that automatically adds implicit team memberships to the team membership record for the particular data item when a new explicit team membership is added to the team membership record based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 4 (depends on 1)

The apparatus of claim 1, wherein the security module further comprises computer instructions that automatically remove implicit team memberships from the team membership record for the particular data item when an explicit team membership is removed from the team membership record for the particular data item based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 5 (depends on 1)

The apparatus of claim 1, wherein the security module further comprises computer instructions that enforce the security of each data item based on the team membership record.

### Claim 6 (depends on 5)

The apparatus of claim 5, wherein the computer instructions that enforce the security of each data item further comprises computer instructions that modify a piece of SQL code of a query to the data store to enforce the security of each data item based on the team membership record.

### Claim 7 (depends on 6)

The apparatus of claim 6, wherein the computer instructions that modify the SQL code of a query further comprises computer instructions that join on the team membership record that matches an identifier of a user that is retrieving the particular data record with a team_id from the particular data item to determine if the user can access the data item.

### Claim 8 (depends on 6)

The apparatus of claim 6 wherein the query further comprises an SQL query.

### Claim 9 (depends on 1)

The apparatus of claim 1 wherein each data item has a data record.

### Claim 10 (depends on 9)

The apparatus of claim 9, wherein each data record is a data table.

### Claim 11 (depends on 1)

The apparatus of claim 1, wherein the team hierarchy further comprises a team, one or more teams, a plurality of teams at one or more levels of a team hierarchy.

### Claim 12

A method for controlling access to a data item that is part of a data access system wherein the data item is stored in a data store, the method comprising:
retrieving, when a particular data item is requested, a team membership record for a data item and a team hierarchy assigned to the particular data item, wherein the team hierarchy includes one or more of an explicit team membership for a member explicitly assigned to the team hierarchy that owns the particular data item and an implicit team membership that identifies a second member that has an explicit team member who reports to the second member; and
modifying the team assignment for the particular data item to allow access to that particular data item to all members of the team hierarchy.

### Claim 13 (depends on 12)

The method of claim 12 further comprising automatically creating an implicit team membership for a member based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 14 (depends on 12)

The method of claim 12 further comprising automatically adding an implicit team membership for a member to the team hierarchy assigned to the particular data item when a new explicit team membership is added to the team for the particular data item based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 15 (depends on 12)

The method of claim 12 further comprising automatically removing an implicit team membership for a member from the team hierarchy assignment to the particular data item when an explicit team membership is removed from the team for the particular data item based on the members associated with the data access system and the reporting relationship of the members associated with the data access system.

### Claim 16 (depends on 12)

The method of claim 12 further comprising enforcing the security of each data item based on the team membership record when the data item is requested.

### Claim 17 (depends on 16)

The method of claim 16, wherein enforcing of each data item further comprises modifying the SQL code of a query to the data store to enforce the security of each data item based on the team membership record.

### Claim 18 (depends on 17)

The method of claim 17, wherein modifying the SQL code of the query further comprises performing a join on the team membership record that matches an identifier of a user that is retrieving the particular data record with a team_id from the particular data item to determine if the user can access the data item.

### Claim 19 (depends on 12)

The method of claim 12, wherein the team hierarchy further comprises a team, one or more teams, a plurality of teams at one or more levels of a team hierarchy.
