Back to results
US 2009/0157687 A1Published application
Team based row level security system and method
AssigneeSugarCRM Inc.
InventorsJacob Taylor, Clinton Oram, John Roberts
Life of this patent
Estimating the term…
Abstract
A team based row level security system and method are provided that permits items of data to be shared across a team.
Claims19
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.
1 more element
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.
Dependencies are inferred from the claim text.