×

METHODS AND SYSTEMS FOR CONTROLLING ACCESS TO CUSTOM OBJECTS IN A DATABASE

  • US 20140095545A1
  • Filed: 09/30/2013
  • Published: 04/03/2014
  • Est. Priority Date: 10/03/2006
  • Status: Active Grant
First Claim
Patent Images

1. A method for controlling access to diverse custom objects in a custom entity share table, including:

  • storing a plurality of custom object types for a plurality of shared database tenants in a custom entity share table, wherein;

    a first custom object for a first tenant has a first schema including a first set of custom fields;

    a second custom object for a second tenant has a second schema including a second set of custom fields;

    the first and second custom objects are both stored in the same table despite having different sets of custom fields;

    the first and second custom objects are both associated with fields for tenant id and object type;

    receiving a request on behalf of a user belonging to a particular tenant for access to custom objects of a particular custom object type;

    identifying a particular tenant and a particular group within the particular organization to which the user belongs;

    determining whether the particular group has access to the particular custom object type requested and, if it does, filtering custom objects in the custom entity share table by at least tenant id and by custom object type to select custom objects responsive to the request received; and

    responding to the request with at least some selected custom objects of the particular custom object type responsive to the request received and to which the user is entitled to have access.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×