Patent Application
20190394232
A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever.
Embodiments of invention relate generally to secure access to data stored in a database. More specifically, embodiments of the invention relate to techniques that allow multiple concurrent accesses to secure data in a database network system.
The subject matter discussed in the background section should not be assumed to be prior art merely as a result of its mention in the background section. Similarly, a problem mentioned in the background section or associated with the subject matter of the background section should not be assumed to have been previously recognized in the prior art. The subject matter in the background section merely represents different approaches, which in and of themselves may also be inventions.
A Session ID in most web applications is represented by a session cookie on the client browser. These session cookies are unique to a given domain, such as
First.exampledomain.com
and
Second.exampledomain.com.
Within a given browser instance, only a single user may be logged in to the web application that behaves this way. If a single physical user has multiple User Identities (IUs) within the application, they cannot be logged in to more than one Identity in the same browser. For example: jsmith1@acme.com and jsmith2@acme.com are two identities belonging to John Smith. If John is logged in as jsmith1 using the Firefox web browser, he must either log out, or launch a new browser (such as Internet Explorer) to be logged in as jsmith2.
In certain situations, it is desirable to be logged in as multiple users concurrently without needing to use different computers or different browsers. However, the rendering of a given HTML page and its associated DOM (Document Object Model) elements, scripts, CSS, and other web components rely on the browser to manage user Identity through its session cookie (or session ID).
In the following drawings like reference numbers are used to refer to like elements. Although the following figures depict various examples of the invention, the invention is not limited to the examples depicted in the figures.
In the following description, numerous specific details are set forth. However, embodiments of the invention may be practiced without these specific details. In other instances, well-known circuits, structures and techniques have not been shown in detail in order not to obscure the understanding of this description.
In one embodiment, in order to allow for multiple concurrent identities, a server component can be written to understand and segregate identities, and dynamically re-write portions of a user interface, for example a HTML page and its related web components. In one embodiment, this server component initiates authentication and a new session for the second identity by looping calls (e.g., HTTP calls) back on itself, and dynamically re-writing responses so that the existing content (e.g., HTML page and components) are not over-written by the session for the second identity.
In one embodiment, there is also client code that bridges the gap between the multiple identities. This component understands the difference between the existing page/components, and the components that were re-written for the second identity. In one embodiment, this client code can utilize the same core elements of the page for both identities, meaning that the application server does not need to alter its behavior, or even be aware that multiple identities exist within the same browser context.
This may be useful, for example, in the use case where an administrator needs to configure and test privilege levels and profiles for other users in the organization. Without the feature(s) described herein, the Administrator must make a change to a user profile, log out, log in as a user with that profile, test the change, and then log out again. Using the feature(s) described herein, the Administrator can be logged in as himself/herself, and be logged in as another identity within the same window and same browser context. The Administrator can make a change to the user profile for the second identity and test that change without any additional effort.
Using this mechanism, the transition between the two identities may be invisible to the user, and the web application looks and behaves as expected for both identities and their respective privilege levels. Thus, the mechanisms described herein may provide a more efficient use of time for users of many types of computing environments including, for example, multitenant database environments.
As another example, a user's privilege level may be increased for a specific operation or operations, or for a specified period of time. Thus, an administrator may be given one or more “super user” privileges. These privileges may be limited in time and/or functionality to avoid abuse. Thus, while many examples are provided herein for a system administrator using a second identity having a reduced privilege level, the same mechanisms may be utilized to increase a user's privilege level.
As used herein, the term multi-tenant database system refers to those systems in which various elements of hardware and software of the database system may be shared by one or more customers. For example, a given application server may simultaneously process requests for a great number of customers, and a given database table may store rows for a potentially much greater number of customers.
In one embodiment, a multi-tenant database system utilizes tenant identifiers (IDs) within a multi-tenant environment to allow individual tenants to access their data while preserving the integrity of other tenant's data. In one embodiment, the multitenant database stores data for multiple client entities each identified by a tenant ID having one of one or more users associated with the tenant ID. Users of each of multiple client entities can only access data identified by a tenant ID associated with their respective client entity. In one embodiment, the multitenant database is a hosted database provided by an entity separate from the client entities, and provides on-demand and/or real-time database service to the client entities.
In the example of
Server device 160 may be any wired or wireless device that can provide access to resource 180 to client devices 110 and 130 over network 150. For example, server device 160 may be a web server, or server device 160 may be a database server. Access manager 170 operates to control access to resource 180. Resource 180 may be any type of electronic resource on server device 160. For example, resource 180 may be a database in a multitenant environment, resource 180 may be a shared printer, resource 180 may be electronic files stored on server device 160.
Continuing the example started above, a system administrator may use client device 110 and browser 120 to access various network resources including resource 180 on server device 160. Another user, not having system administrator level privileges, may access various network resources including resource 180 on server device 160. Because the user of client device 110 and the user of client device 130 may have different privilege levels, they may have access to different feature sets and different data sets. The concept of differing privilege levels is known in the art.
The Same Origin Policy (SOP), which is enforced by most browsers prevent straight forward access utilizing multiple identities. The Same Origin Policy is a security concept for a number of browser-side programming languages that permits scripts running on pages originating from the same site to access each other's methods and properties with no specific restrictions, but prevents access to most methods and properties across pages on different sites. This mechanism is utilized, for example, with cookies to maintain authenticated user sessions, as servers act based on the cookie information to reveal information or take state-changing actions. Thus, when using a browser that supports SOP, the system administrator cannot use browser 120 to access resource 180 as the user of browser 140.
Another browser security feature is Fully Qualified Domain Name (FQDN), also referred to as an Absolute Domain Name, which specifies a domain within a tree hierarchy of the Domain Name System (DNS). The FQDN specifies all domain levels, including the top-level domain and the root domain. A fully qualified domain name can only be interpreted one way.
In one embodiment, a first user (e.g., the system administrator) may access resource 180 by using browser 120 and a first cookie (e.g., NA1.resource.com) and a second user may access resource 180 using browser 140 and a second cookie (e.g., NA2.resource.com). The first and second cookies may have the same or different privilege levels. In the example of the first user being a system administrator, the second user and second cookie will have a lower privilege level.
In one embodiment, client device 110, through browser 120 or another component, may create a user profile and or cookie that is a child entity of the first profile. In one embodiment, the child cookie has a different domain (e.g., NA1.interface.com) than the first cookie. By generating a cookie having a different domain than the first cookie, the user of browser 120 may be able to access resource 180 using multiple user identities that may have different privilege levels.
Thus, when the user of browser 120 attempts to access resource 180, the access appears to access manager 170 and resource 180 as coming from a different user. In one embodiment, access manager 170 receives the access request associated with the child cookie (e.g., NA1.interface.com) and reconfigures the request before forwarding the request to resource 180. In one embodiment, the request with the child cookie includes information regarding the user identity and/or privilege level of the user for which access to resource 180 is sought.
In one embodiment, access manager 170 includes a mapping or other mechanism to track the child cookie identity and/or privilege level and the identity and/or privilege level of the user of browser 140. Access manager 170 generates a request to resource 180 corresponding to the request from browser 120, but with the user identities and/or other information corresponding to the user of browser 140. Thus, resource 180 receives an access request that appears to be from browser 140 and the user thereof.
In response to the access request, resource 180 responds as if the request came from browser 140. Access manager 170 receives the response from resource 180 and reconfigures the response. In one embodiment, access manager 170 generates a response to browser 120 utilizing the response data from resource 180 and the child user identity information. Thus, browser 120 will receive a response from server device 160 that may appear as if resource 180 was accessed by browser 120 with the user identity (e.g., NA2.resource.com) of the user of client device 130.
In one embodiment, browser 120 may provide a graphical user interface that provides a portion of the interface corresponding to the parent user identity and a portion of the interface corresponding to the child/second identity. With this interface, a user of browser 120 may have access to features and/or configurations corresponding to multiple privilege levels.
A request is received for a second identity, 210. In one environment, the ability to request a second identity is tied to a user privilege level so that only users having a sufficiently high privilege level (e.g., system administrator) may be allowed to request a second identity.
In response to receiving the request for the second identity, a child identity is generated, 220. In one embodiment, the child identity has a corresponding browser cookie that has a different domain than the browser cookie corresponding to the parent identity. The child identity is utilized for accessing one or more remote resources as a different user.
A request is transmitted to a remote resource using the child identity, 230. As described above, the child identity is utilized by an access manager to regenerate access requests to appear as if from the browser of another user. That is, the browser and/or client device from which the requests utilizing the child identity are transmitted communicates with the remote resource using only the child identity. That browser is not required to manage the mapping of the child identity to the identity to be emulated.
In one embodiment, the child identity and associated cookies (and other identifiers, if necessary) may be generated by the remote resource when the user is accessing the resource using the parent identity. In another embodiment, the child identity and associated cookies may be generated by a local component, for example, a browser plug-in.
At some later time, the browser may receive a response from the remote resource, 240. This response utilizes the child identity so that the browser may satisfy the Same Origin Policy and Fully Qualified Domain Name policies as described above. When the browser receives the response from the remote resource, the browser may display data based on the response, 250. In one embodiment, the browser may display information corresponding to both identities simultaneously.
In one embodiment, user interface 300 may include at least two regions: parent identity region 310 and child identity region 320. In one embodiment, child identity region provides information corresponding to functionality and operations for the child identity. That is, child identity region 320 may provide a view as if the user of the browser were operating as the second identity corresponding to the child identity.
For example, a system administrator may be able to access a remote resource (e.g., a multitenant database environment) as another user and have in child identity region 320 the view as if the system administrator were that user. This may allow the system administrator to have the experience of the other user and thereby diagnose problems experienced by the other user without having to log out and log in repeatedly, as described above.
Parent identity region 310 may provide the user with functionality not available to the child identity. Using the system administrator example above, parent identity region 310 may provide system administrator tools available only to a system administrator. This may allow the system administrator to operate as a system administrator while also diagnosing problems as another user in child identity region 320. Other uses of parent identity region 310 and child identity region 320 may also be supported.
Primary identity agent 400 includes control logic 410, which implements logical functional control to direct operation of primary identity agent 400, as software and/or hardware associated with directing operation of primary identity agent 400. Logic may be hardware logic circuits and/or software routines. In one embodiment, parent identity agent 400 includes one or more applications 412, which represent code sequence and/or programs that provide instructions to control logic 410.
Primary identity agent 400 includes memory 414, which represents a memory device and/or access to a memory resource for storing data and/or instructions. Memory 414 may include memory local to parent identity agent 400, as well as, or alternatively, including memory of the host system on which primary identity agent 400 resides. Primary identity agent 400 also includes one or more interfaces 416, which represent access interfaces to/from (an input/output interface) primary identity agent 400 with regard to entities (electronic or human) external to primary identity agent 400.
Parent identity agent 400 also includes parent identity engine 420, which represents one or more functions or modules that enable parent identity agent 400 to provide the services as described above. The example of
Request evaluation module 430 provides security and/or authentication functionality to protect against unauthorized users generating child identities and accessing resources as other users. In one embodiment, request evaluation module 430 restricts generation of child identities to specified privilege levels (e.g., system administrator, super user, etc.). In one embodiment, request evaluation module 430 further limits the uses of the child identity to a specified list of authorized functions so that the child identity is only used for legitimate purposes. In alternate embodiments, request evaluation module 430 may provide additional functionality.
Child identity module 440 functions to provide the identity mechanisms (e.g., cookies, mapping information) associated with the child identity. In one embodiment, child identity module 440 provides mapping information to the access manager (e.g., 170 in
Child request module 450 provides functionality to generate a request to a remote resource using the child identity. In one embodiment, child request module 450 causes a browser accessing the remote resource to generate one or more requests with the child identity rather than the parent identity without requiring the user to log out or otherwise explicitly change identities.
Display module 460 causes the browser to display information received from the remote resource using the parent identity and/or the child identity. In one embodiment, display module 460 causes the browser to generate a display as discussed above with respect to
A request using the child identity is received, 510. In one embodiment, the request is received from a browser on a client device. The request may include (or be associated with) a cookie or other identifier indicating the child identity, where the child identity is a child of a parent identity being used by the browser making the request. In one embodiment, the child identity has a different domain than the parent identity. Other and/or different distinguishing characteristics may also be utilized.
The access manager (or other component) may reconfigure the request with the target identity, 520. In one embodiment, the access manager maintains a table or other mapping between child identities and target identities. The access manager may use this mapping information to “replace” the child identity with the target identity so that the requesting browser operates using the child identity and the resource being accessed operates using the target identity. Using the system administrator example from above, the target identity is the identity of the user accessing resource 180 using browser 140. Thus, the access appears to the resource as if it came from a different browser and/or a different user.
The access manager (or other component) forwards the reconfigured request to the resource to be accessed, 530. The resource processes the reconfigured request as if it were a request corresponding to the target identity from the browser corresponding to the target identity. The access manager (or other component) receives the response from the resource, 540.
The access manager (or other component) reconfigures the response from the target identity to the child identity, 550. The access manager may use the mapping information to “replace” the target identity with the child identity to perform the opposite reconfiguration as described above. The response with the child identity is returned to the requesting browser, 560. Thus, the response appears to the browser as if it came from the resource using the child identity.
Resource management agent 600 includes control logic 610, which implements logical functional control to direct operation of resource management agent 600, as software and/or hardware associated with directing operation of resource management agent 600. Logic may be hardware logic circuits and/or software routines. In one embodiment, resource management agent 600 includes one or more applications 612, which represent code sequence and/or programs that provide instructions to control logic 610.
Resource management agent 600 includes memory 614, which represents a memory device and/or access to a memory resource for storing data and/or instructions. Memory 614 may include memory local to resource management agent 600, as well as, or alternatively, including memory of the host system on which resource management agent 600 resides. Resource management agent 600 also includes one or more interfaces 616, which represent access interfaces to/from (an input/output interface) resource management agent 600 with regard to entities (electronic or human) external to resource management agent 600.
Resource management agent 600 also includes resource management engine 620, which represents one or more functions or modules that enable resource management agent 600 to provide the services as described above. The example of
Identity mapping module 680 maintains a mapping between one or more child identities and one or more corresponding target identities. In one embodiment, identity mapping module 680 also maintains privilege level and/or functionality limitations associated with the identities. Identity mapping module 680 may derive information from incoming requests and/or may receive explicit mapping information related to identities to be used to access a resource.
Request management module 630 receives requests from remote client devices and determines whether the identity associated with individual requests is the correct identity to use, or if the identity associated with the request is a child identity that should be processed as described above, with respect to
Request reconfiguration module 640 operates to modify the request received by request management module 640 to appear as if it were from a browser accessing the resource using the target identity. In one embodiment, request reconfiguration module 640 generates a new request that includes the target identity. Request reconfiguration module 640 may operate with information from identity mapping module 680 to reconfigure the request.
Access management module 650 operates to control access to the resource using the requests and associated identities. Access management module 650 may operate to enforce privilege levels and/or functionality restrictions based on, for example, user identities and functionality conditions. For example, access management module 650 may allow access to a resource for the target identity, but not for the child identity, or access management module 650 may allow different levels of access for the child identity and the target identity.
Response reconfiguration module 660 operates to modify the response received from the resource to appear as if it were for the browser accessing the resource using the target identity. In one embodiment, response reconfiguration module 660 generates a new response that includes the child identity. Response reconfiguration module 660 may operate with information from identity mapping module 680 to reconfigure the response.
Response management module 670 operates to communicate the reconfigured response from response configuration module 660 to the requesting browser. In one embodiment, response management module provides the response as a HTTP response, or any other type of network protocol that may be supported.
Environment 710 is an environment in which an on-demand database service exists. User system 712 may be any machine or system that is used by a user to access a database user system. For example, any of user systems 712 can be a handheld computing device, a mobile phone, a laptop computer, a work station, and/or a network of computing devices. As illustrated in
An on-demand database service, such as system 716, is a database system that is made available to outside users that do not need to necessarily be concerned with building and/or maintaining the database system, but instead may be available for their use when the users need the database system (e.g., on the demand of the users). Some on-demand database services may store information from one or more tenants stored into tables of a common database image to form a multi-tenant database system (MTS). Accordingly, “on-demand database service 716” and “system 716” will be used interchangeably herein. A database image may include one or more database objects.
A relational database management system (RDMS) or the equivalent may execute storage and retrieval of information against the database object(s). Application platform 718 may be a framework that allows the applications of system 716 to run, such as the hardware and/or software, e.g., the operating system. In an embodiment, on-demand database service 716 may include an application platform 718 that enables creation, managing and executing one or more applications developed by the provider of the on-demand database service, users accessing the on-demand database service via user systems 712, or third party application developers accessing the on-demand database service via user systems 712.
The users of user systems 712 may differ in their respective capacities, and the capacity of a particular user system 712 might be entirely determined by permissions (permission levels) for the current user. For example, where a salesperson is using a particular user system 712 to interact with system 716, that user system has the capacities allotted to that salesperson. However, while an administrator is using that user system to interact with system 716, that user system has the capacities allotted to that administrator. In systems with a hierarchical role model, users at one permission level may have access to applications, data, and database information accessible by a lower permission level user, but may not have access to certain applications, database information, and data accessible by a user at a higher permission level. Thus, different users will have different capabilities with regard to accessing and modifying application and database information, depending on a user's security or permission level.
Network 714 is any network or combination of networks of devices that communicate with one another. For example, network 714 can be any one or any combination of a LAN (local area network), WAN (wide area network), telephone network, wireless network, point-to-point network, star network, token ring network, hub network, or other appropriate configuration. As the most common type of computer network in current use is a TCP/IP (Transfer Control Protocol and Internet Protocol) network, such as the global internetwork of networks often referred to as the “Internet” with a capital “I,” that network will be used in many of the examples herein. However, it should be understood that the networks that the present invention might use are not so limited, although TCP/IP is a frequently implemented protocol.
User systems 712 might communicate with system 716 using TCP/IP and, at a higher network level, use other common Internet protocols to communicate, such as HTTP, FTP, AFS, WAP, etc. In an example where HTTP is used, user system 712 might include an HTTP client commonly referred to as a “browser” for sending and receiving HTTP messages to and from an HTTP server at system 716. Such an HTTP server might be implemented as the sole network interface between system 716 and network 714, but other techniques might be used as well or instead. In some implementations, the interface between system 716 and network 714 includes load sharing functionality, such as round-robin HTTP request distributors to balance loads and distribute incoming HTTP requests evenly over a plurality of servers. At least as for the users that are accessing that server, each of the plurality of servers has access to the MTS' data; however, other alternative configurations may be used instead.
In one embodiment, system 716, shown in
With a multi-tenant system, data for multiple tenants may be stored in the same physical database object, however, tenant data typically is arranged so that data of one tenant is kept logically separate from that of other tenants so that one tenant does not have access to another tenant's data, unless such data is expressly shared. In certain embodiments, system 716 implements applications other than, or in addition to, a CRM application. For example, system 16 may provide tenant access to multiple hosted (standard and custom) applications, including a CRM application. User (or third party developer) applications, which may or may not include CRM, may be supported by the application platform 718, which manages creation, storage of the applications into one or more database objects and executing of the applications in a virtual machine in the process space of the system 716.
One arrangement for elements of system 716 is shown in
Several elements in the system shown in
Each user system 712 also typically includes one or more user interface devices, such as a keyboard, a mouse, trackball, touch pad, touch screen, pen or the like, for interacting with a graphical user interface (GUI) provided by the browser on a display (e.g., a monitor screen, LCD display, etc.) in conjunction with pages, forms, applications and other information provided by system 716 or other systems or servers. For example, the user interface device can be used to access data and applications hosted by system 716, and to perform searches on stored data, and otherwise allow a user to interact with various GUI pages that may be presented to a user. As discussed above, embodiments are suitable for use with the Internet, which refers to a specific global internetwork of networks. However, it should be understood that other networks can be used instead of the Internet, such as an intranet, an extranet, a virtual private network (VPN), a non-TCP/IP based network, any LAN or WAN or the like.
According to one embodiment, each user system 712 and all of its components are operator configurable using applications, such as a browser, including computer code run using a central processing unit such as an Intel Pentium® processor or the like. Similarly, system 716 (and additional instances of an MTS, where more than one is present) and all of their components might be operator configurable using application(s) including computer code to run using a central processing unit such as processor system 717, which may include an Intel Pentium® processor or the like, and/or multiple processor units.
A computer program product embodiment includes a machine-readable storage medium (media) having instructions stored thereon/in which can be used to program a computer to perform any of the processes of the embodiments described herein. Computer code for operating and configuring system 716 to intercommunicate and to process webpages, applications and other data and media content as described herein are preferably downloaded and stored on a hard disk, but the entire program code, or portions thereof, may also be stored in any other volatile or non-volatile memory medium or device as is well known, such as a ROM or RAM, or provided on any media capable of storing program code, such as any type of rotating media including floppy disks, optical discs, digital versatile disk (DVD), compact disk (CD), microdrive, and magneto-optical disks, and magnetic or optical cards, nanosystems (including molecular memory ICs), or any type of media or device suitable for storing instructions and/or data. Additionally, the entire program code, or portions thereof, may be transmitted and downloaded from a software source over a transmission medium, e.g., over the Internet, or from another server, as is well known, or transmitted over any other conventional network connection as is well known (e.g., extranet, VPN, LAN, etc.) using any communication medium and protocols (e.g., TCP/IP, HTTP, HTTPS, Ethernet, etc.) as are well known.
It will also be appreciated that computer code for implementing embodiments of the present invention can be implemented in any programming language that can be executed on a client system and/or server or server system such as, for example, C, C++, HTML, any other markup language, Java™, JavaScript, ActiveX, any other scripting language, such as VBScript, and many other programming languages as are well known may be used. (Java™ is a trademark of Sun Microsystems, Inc.).
According to one embodiment, each system 716 is configured to provide webpages, forms, applications, data and media content to user (client) systems 712 to support the access by user systems 712 as tenants of system 716. As such, system 716 provides security mechanisms to keep each tenant's data separate unless the data is shared. If more than one MTS is used, they may be located in close proximity to one another (e.g., in a server farm located in a single building or campus), or they may be distributed at locations remote from one another (e.g., one or more servers located in city A and one or more servers located in city B).
As used herein, each MTS could include one or more logically and/or physically connected servers distributed locally or across one or more geographic locations. Additionally, the term “server” is meant to include a computer system, including processing hardware and process space(s), and an associated storage system and database application (e.g., OODBMS or RDBMS) as is well known in the art. It should also be understood that “server system” and “server” are often used interchangeably herein. Similarly, the database object described herein can be implemented as single databases, a distributed database, a collection of distributed databases, a database with redundant online or offline backups or other redundancies, etc., and might include a distributed database or storage network and associated processing intelligence.
User system 712, network 714, system 716, tenant data storage 722, and system data storage 724 were discussed above in
As shown by
The tenant data 723 might be divided into individual tenant storage areas 812, which can be either a physical arrangement and/or a logical arrangement of data. Within each tenant storage area 812, user storage 814 and application metadata 816 might be similarly allocated for each user. For example, a copy of a user's most recently used (MRU) items might be stored to user storage 814. Similarly, a copy of MRU items for an entire organization that is a tenant might be stored to tenant storage area 812. A UI 830 provides a user interface and an API 832 provides an application programmer interface to system 716 resident processes to users and/or developers at user systems 712. The tenant data and the system data may be stored in various databases, such as one or more Oracle databases.
Application platform 718 includes an application setup mechanism 838 that supports application developers' creation and management of applications, which may be saved as metadata into tenant data storage 722 by save routines 836 for execution by subscribers as one or more tenant process spaces 804 managed by tenant management process 810 for example. Invocations to such applications may be coded using PL/SOQL 834 that provides a programming language style interface extension to API 832.
A detailed description of some PL/SOQL language embodiments is discussed in commonly owned co-pending U.S. Provisional Patent Application 60/828,192 entitled, PROGRAMMING LANGUAGE METHOD AND SYSTEM FOR EXTENDING APIS TO EXECUTE IN CONJUNCTION WITH DATABASE APIS, by Craig Weissman, filed Oct. 4, 2006, which is incorporated in its entirety herein for all purposes. Invocations to applications may be detected by one or more system processes, which manages retrieving application metadata 816 for the subscriber making the invocation and executing the metadata as an application in a virtual machine.
Each application server 800 may be communicably coupled to database systems, e.g., having access to system data 725 and tenant data 723, via a different network connection. For example, one application server 8001 might be coupled via the network 714 (e.g., the Internet), another application server 800N-1 might be coupled via a direct network link, and another application server 800N might be coupled by yet a different network connection. Transfer Control Protocol and Internet Protocol (TCP/IP) are typical protocols for communicating between application servers 800 and the database system. However, it will be apparent to one skilled in the art that other transport protocols may be used to optimize the system depending on the network interconnect used.
In certain embodiments, each application server 800 is configured to handle requests for any user associated with any organization that is a tenant. Because it is desirable to be able to add and remove application servers from the server pool at any time for any reason, there is preferably no server affinity for a user and/or organization to a specific application server 800. In one embodiment, therefore, an interface system implementing a load balancing function (e.g., an F5 Big-IP load balancer) is communicably coupled between the application servers 800 and the user systems 712 to distribute requests to the application servers 800.
In one embodiment, the load balancer uses a least connections algorithm to route user requests to the application servers 800. Other examples of load balancing algorithms, such as round robin and observed response time, also can be used. For example, in certain embodiments, three consecutive requests from the same user could hit three different application servers 800, and three requests from different users could hit the same application server 800. In this manner, system 716 is multi-tenant, wherein system 716 handles storage of, and access to, different objects, data and applications across disparate users and organizations.
As an example of storage, one tenant might be a company that employs a sales force where each salesperson uses system 716 to manage their sales process. Thus, a user might maintain contact data, leads data, customer follow-up data, performance data, goals and progress data, etc., all applicable to that user's personal sales process (e.g., in tenant data storage 722). In an example of a MTS arrangement, since all of the data and the applications to access, view, modify, report, transmit, calculate, etc., can be maintained and accessed by a user system having nothing more than network access, the user can manage his or her sales efforts and cycles from any of many different user systems. For example, if a salesperson is visiting a customer and the customer has Internet access in their lobby, the salesperson can obtain critical updates as to that customer while waiting for the customer to arrive in the lobby.
While each user's data might be separate from other users' data regardless of the employers of each user, some data might be organization-wide data shared or accessible by a plurality of users or all of the users for a given organization that is a tenant. Thus, there might be some data structures managed by system 716 that are allocated at the tenant level while other data structures might be managed at the user level. Because an MTS might support multiple tenants including possible competitors, the MTS should have security protocols that keep data, applications, and application use separate. Also, because many tenants may opt for access to an MTS rather than maintain their own system, redundancy, up-time, and backup are additional functions that may be implemented in the MTS. In addition to user-specific data and tenant specific data, system 716 might also maintain system level data usable by multiple tenants or other data. Such system level data might include industry reports, news, postings, and the like that are sharable among tenants.
In certain embodiments, user systems 712 (which may be client systems) communicate with application servers 800 to request and update system-level and tenant-level data from system 716 that may require sending one or more queries to tenant data storage 722 and/or system data storage 724. System 716 (e.g., an application server 800 in system 716) automatically generates one or more SQL statements (e.g., one or more SQL queries) that are designed to access the desired information. System data storage 724 may generate query plans to access the requested data from the database.
Each database can generally be viewed as a collection of objects, such as a set of logical tables, containing data fitted into predefined categories. A “table” is one representation of a data object, and may be used herein to simplify the conceptual description of objects and custom objects according to the present invention. It should be understood that “table” and “object” may be used interchangeably herein.
Each table generally contains one or more data categories logically arranged as columns or fields in a viewable schema. Each row or record of a table contains an instance of data for each category defined by the fields. For example, a CRM database may include a table that describes a customer with fields for basic contact information such as name, address, phone number, fax number, etc. Another table might describe a purchase order, including fields for information such as customer, product, sale price, date, etc. In some multi-tenant database systems, standard entity tables might be provided for use by all tenants. For CRM database applications, such standard entities might include tables for Account, Contact, Lead, and Opportunity data, each containing pre-defined fields. It should be understood that the word “entity” may also be used interchangeably herein with “object” and “table”.
In some multi-tenant database systems, tenants may be allowed to create and store custom objects, or they may be allowed to customize standard entities or objects, for example by creating custom fields for standard objects, including custom index fields. U.S. patent application Ser. No. 10/817,161, filed Apr. 2, 2004, entitled “Custom Entities and Fields in a Multi-Tenant Database System”, now U.S. Pat. No. 7,779,039 and which is hereby incorporated herein by reference, teaches systems and methods for creating custom objects as well as customizing standard objects in a multi-tenant database system. In certain embodiments, for example, all custom entity data rows are stored in a single multi-tenant physical table, which may contain multiple logical tables per organization. It is transparent to customers that their multiple “tables” are in fact stored in one large table or that their data may be stored in the same table as the data of other customers.
Reference in the specification to “one embodiment” or “an embodiment” means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the invention. The appearances of the phrase “in one embodiment” in various places in the specification are not necessarily all referring to the same embodiment.
While the invention has been described by way of example and in terms of the specific embodiments, it is to be understood that the invention is not limited to the disclosed embodiments. To the contrary, it is intended to cover various modifications and similar arrangements as would be apparent to those skilled in the art. Therefore, the scope of the appended claims should be accorded the broadest interpretation so as to encompass all such modifications and similar arrangements.
This application is a continuation of U.S. patent application Ser. No. 12/973,618 entitled “METHODS AND SYSTEMS FOR ACCESSING A RESOURCE WITH MULTIPLE USER IDENTITIES,” filed Dec. 20, 2010, which claims the benefit of U.S. Provisional Patent Application 61/358,124 entitled “METHODS AND SYSTEMS FOR MAINTAINING MULTIPLE CONCURRENT PRIVILEGE LEVELS IN A MULTI-TENANT DATABASE ENVIRONMENT,” filed Jun. 24, 2010. All of the above-listed applications are hereby incorporated by reference in their entirety for all purposes.
| Number | Date | Country | |
|---|---|---|---|
| 61358124 | Jun 2010 | US |
| Number | Date | Country | |
|---|---|---|---|
| Parent | 12973618 | Dec 2010 | US |
| Child | 16560883 | US |
