×

Methods and systems for controlling access to custom objects in a database

  • US 9,378,392 B2
  • Filed: 09/30/2013
  • Issued: 06/28/2016
  • Est. Priority Date: 10/03/2006
  • Status: Active Grant
First Claim
Patent Images

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

  • storing a plurality of custom object types for a plurality of shared database tenants in a custom entity share table in a memory, 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 a same custom entity share table despite having different sets of custom fields; and

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

    receiving a user request for access to custom objects of a particular custom object type and identifying a particular group of users to which the user belongs with a particular tenant id in response to the user request; and

    determining whether the particular group has access to the particular custom object type requested and, responsively, accessing and returning at least some custom objects in the custom entity share table based at least on the particular tenant id and the particular custom object type to select at least some of the plurality of the custom objects responsive to the user request.

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