On-demand service system, method and computer program product for linking a custom share row cause to a sharing record associated with a custom object

• US 8,312,013 B1
• Filed: 05/08/2009
• Issued: 11/13/2012
• Est. Priority Date: 05/08/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Smith, Andrew, Weissman, Craig, Jain, Punit
• Primary Examiner(s): NGUYEN, PHONG H
• Application Number:
  US12/463,320
• Time in Patent Office: 1,285 Days
• Field of Search: 707/704, 707/726, 707/781, 707/785
• US Class Current: 707/726
• CPC Class Codes: G06F 16/211 Schema design and management

Abstract

In accordance with embodiments, there are provided mechanisms and methods for linking a custom share row cause to a sharing record associated with a custom object in an on-demand service. These mechanisms and methods for linking custom share row causes to sharing records associated with an instance of a custom object in an on-demand service can enable a user or code executed by a user to share a custom object record with one or more users and to specify a custom row cause in that sharing record. The ability of embodiments to link custom share row causes to sharing records may allow users of such on-demand services to utilize custom row causes to determine why a sharing record was added and to identify the source of a sharing record.

Claims

1. A computer implemented method, comprising:

receiving from one of a plurality of tenants of an on-demand service, a custom share row cause for a custom object managed by the on-demand service; and

linking the custom share row cause to a sharing record associated with an instance of the custom object;

wherein the sharing record controls access by users to the instance of the custom object by specifying at least one of the users to which access to the instance of the custom object is granted, and wherein the custom share row cause is linked to the sharing record for uniquely identifying the sharing record specifying the at least one of the users to which the access to the instance of the custom object is granted and for describing an event prompting creation of the sharing record;

wherein adding the sharing record to the instance of the custom object is in response to a determination that the sharing record is different from other sharing records previously added to the instance of the custom object, wherein the determination is based on the custom share row cause linked to the sharing record and the at least one of the users specified by the sharing record.

2. The method of claim 1, wherein the custom share row cause for the custom object managed by the on-demand service is received from a tenant administrator.

3. The method of claim 2, wherein the use of the custom row cause in a sharing record allows a maintaining of access granted by an associated sharing record during an ownership change.

4. The method of claim 1, further comprising blocking non-administrators from manipulating the sharing related to the instance of the custom object using a custom sharing row cause.

5. The method of claim 4, wherein blocking the non-administrators from manipulating the sharing related to the instance of the custom object includes blocking the non-administrators from deleting share rows associated with the custom object using a custom sharing row cause.

6. The method of claim 1, wherein the one of the plurality of tenants of the on-demand service is capable of defining the custom object.

7. The method of claim 6, wherein the one of the plurality of tenants of the on-demand service is capable of defining the custom share row cause.

8. The method of claim 1, wherein the one of the plurality of tenants of the on-demand service is capable of adding sharing rows to the instance of the custom object multiple times.

9. The method of claim 8, wherein a plurality of sharing records using a custom share row cause are received by the one of a plurality of tenants of the on-demand service.

10. The method of claim 9, further comprising determining whether each of the sharing records using the custom share row cause is different.

11. The method of claim 10, wherein the one of a plurality of tenants of the on-demand service are capable of adding sharing rows to the instance of the custom object multiple times, if it is determined that each of the plurality of sharing rows are different based on the custom row cause and user specified in the sharing row.

12. The method of claim 1, wherein the presence of the custom share row cause is used to determine whether a new sharing record is inserted or an existing record is upserted.

13. The method of claim 1, wherein the presence of the custom share row cause is used to identify a source of the sharing record.

14. The method of claim 1, wherein an upsert operation is performed in response to a command to insert a sharing row, if it is determined that the sharing row to be inserted is already present in the custom object.

15. The method of claim 1, wherein the custom share row cause definition is packaged for distribution to other tenants.

16. The method of claim 1, wherein one or more labels associated with the custom share row cause definition are translatable.

17. The method of claim 1, wherein the on-demand service includes a multi-tenant on-demand database service.

18. The method of claim 1, wherein a plurality of sharing records are associated with the instance of the custom object by being added to the instance of the custom object.

19. The method of claim 18, wherein the custom share row cause linked to the sharing record is used to distinguish the sharing record from remaining ones of the plurality of sharing records associated with the instance of the custom object.

20. The method of claim 18, wherein each of the sharing records indicates at least one of a user and code with which the instance of the custom object is shared, for enabling access to the instance of the custom object by the at least one of the user and the code.

21. A tangible machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

receiving from one of a plurality of tenants of an on-demand service, a custom share row cause for a custom object managed by the on-demand service; and

linking the custom share row cause to a sharing record associated with an instance of the custom object;

wherein the sharing record controls access by users to the instance of the custom object by specifying at least one of the users to which access to the instance of the custom object is granted, and wherein the custom share row cause is linked to the sharing record for uniquely identifying the sharing record specifying the at least one of the users to which the access to the instance of the custom object is granted and for describing an event prompting creation of the sharing record;

wherein adding the sharing record to the instance of the custom object is in response to a determination that the sharing record is different from other sharing records previously added to the instance of the custom object, wherein the determination is based on the custom share row cause linked to the sharing record and the at least one of the users specified by the sharing record.

22. An apparatus, 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;

receiving from one of a plurality of tenants of an on-demand service, a custom share row cause for a custom object managed by the on-demand service; and

linking the custom share row cause to a sharing record associated with an instance of the custom object;

wherein the sharing record controls access by users to the instance of the custom object by specifying at least one of the users to which access to the instance of the custom object is granted, and wherein the custom share row cause is linked to the sharing record for uniquely identifying the sharing record specifying the at least one of the users to which the access to the instance of the custom object is granted and for describing an event prompting creation of the sharing record;

wherein adding the sharing record to the instance of the custom object is in response to a determination that the sharing record is different from other sharing records previously added to the instance of the custom object, wherein the determination is based on the custom share row cause linked to the sharing record and the at least one of the users specified by the sharing record.

23. A computer implemented method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising:

transmitting code for receiving from one of a plurality of tenants of an on-demand service, a custom share row cause for a custom object managed by the on-demand service; and

transmitting code for linking the custom share row cause to a sharing record associated with an instance of the custom object;

wherein the sharing record controls access by users to the instance of the custom object by specifying at least one of the users to which access to the instance of the custom object is granted, and wherein the custom share row cause is linked to the sharing record for uniquely identifying the sharing record specifying the at least one of the users to which the access to the instance of the custom object is granted and for describing an event prompting creation of the sharing record;

wherein adding the sharing record to the instance of the custom object is in response to a determination that the sharing record is different from other sharing records previously added to the instance of the custom object, wherein the determination is based on the custom share row cause linked to the sharing record and the at least one of the users specified by the sharing record.

24. A computer implemented method, comprising:

receiving from one of a plurality of tenants of an on-demand service, a custom share row cause for a custom object managed by the on-demand service; and

linking the custom share row cause to a sharing record associated with an instance of the custom object;

wherein the sharing record controls access by users to the instance of the custom object by specifying at least one of the users to which access to the instance of the custom object is granted, and wherein the custom share row cause is linked to the sharing record for uniquely identifying the sharing record specifying the at least one of the users to which the access to the instance of the custom object is granted and for describing an event prompting creation of the sharing record;

wherein multiple sharing records are added to the instance of the object, each of the sharing records specifying the at least one of the users to which access to the instance of the custom object is granted and linked to a different custom share row cause describing a different event prompting creation of the sharing record, such that a single sharing record specifying the at least one of the users to which access to the instance of the custom object is granted is prevented from being associated with multiple descriptions of different events prompting the granting of access to the instance of the custom object by the at least one user.