Search Images Maps Play YouTube News Gmail Drive More »
Sign in
Screen reader users: click this link for accessible mode. Accessible mode has the same essential features but works better with your reader.

Patents

  1. Advanced Patent Search
Publication numberUS7568039 B2
Publication typeGrant
Application numberUS 11/023,921
Publication dateJul 28, 2009
Filing dateDec 27, 2004
Priority dateDec 27, 2004
Fee statusPaid
Also published asCN101084664A, CN101084664B, US7661125, US20060143436, US20080271114, WO2006069901A1
Publication number023921, 11023921, US 7568039 B2, US 7568039B2, US-B2-7568039, US7568039 B2, US7568039B2
InventorsPaul M. Bird, Gayathiri R. Chandran, Curt L. Cotner, Adrian B. Lobo, James W. Pickel, Walid Rjaibi
Original AssigneeInternational Business Machines Corporation
Export CitationBiBTeX, EndNote, RefMan
External Links: USPTO, USPTO Assignment, Espacenet
Method for providing and utilizing a network trusted context
US 7568039 B2
Abstract
A method for establishing a connection between a data server and a middleware server is disclosed. The method includes defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The method also includes establishing the trusted context based on the validating the plurality of trust attributes.
Images(4)
Previous page
Next page
Claims(16)
1. A method for establishing a connection between a middleware server and a data server comprising:
defining data for a trusted context, the data for the trusted context comprising a role that corresponds to at least one privilege on the data server associated with at least one end user, and a plurality of trust attributes corresponding to the defined data between the middleware server and the data server, the plurality of trust attributes comprising at least one of attributes of the middleware server and attributes of at least one end user connected to the middleware server;
receiving a request for the connection from the middleware server including a plurality of middleware attributes;
in response to the received request, validating by matching the plurality of middleware attributes as against the defined plurality of trust attributes;
in response to the validating, establishing the connection to be one of a trusted connection, a non-trusted connection, a temporary connection, and a suspended connection in relation to validation match results; and
managing a resulting trusted connection based on the defined trusted context and the role by providing the privilege on the data server to the associated at least one end user.
2. The method of claim 1 wherein the establishing further includes:
establishing the trusted connection if the plurality of middleware attributes matches the plurality of trust attributes, and establishing one of a non-trusted connection, a temporary connection, and a suspended connection if the plurality of middleware attributes does not match the plurality of trust attributes.
3. The method of claim 1 wherein the defining further includes:
defining a role for the trusted context, the role corresponding to at least one privilege on the data server wherein the role provides for refined management of a resulting trusted connection.
4. The method of claim 3 wherein the at least one privilege includes limiting access to at least one database object to at least one user.
5. The method of claim 4 wherein the at least one user includes at least one end user.
6. The method of claim 3 wherein the role limits the privilege to at least one end user and wherein the method further includes:
allowing an end user to provide an end user identification;
validating the end user identification to determine whether the end user is included in the at least one end user; and
allowing the end user to access the privilege if the end user is one of the at least one end user.
7. The method of claim 3 wherein the privilege flirt her includes allowing reuse of the connection.
8. The method of claim 7 wherein allowing reuse of the connection requires re-authentication of an end user.
9. The method of claim 1 wherein the defining further includes:
setting a time limit for the trusted connection.
10. The method of claim 9 further comprising:
terminating the trusted connection of the time limit is reached.
11. The method of claim 1 wherein the defining further includes:
requiring the trusted connection to be re-established on reuse.
12. The method of claim 11 wherein the requiring step further includes:
requiring an end user to provide an end user identification upon request for a connection.
13. The method of claim 1 further comprising:
associating an end user with at least one role corresponding to the trusted context and to at least one privilege on the data server.
14. A method for establishing a connection between a middleware server and a data server comprising:
defining data for a trusted context, the data for the trusted context comprising a role that corresponds to at least one privilege on the data server associated with at least one end user, and a plurality of trust attributes corresponding to the defined data between the middleware server and the data server, the plurality of trust attributes comprising at least one of attributes of the middleware server and attributes of at least one end user connected to the middleware server;
receiving a request for the connection from the middleware server including a plurality of middleware attributes;
in response to the received request, validating by matching the plurality of middleware attributes as against the defined plurality of trust attributes;
in response to the validating, establishing the connection to be one of a trusted connection, a non-trusted connection, a temporary connection, and a suspended connection in relation to validation match results; and
managing a resulting trusted connection based on the defined trusted context and the role by providing the privilege on the data server to the associated at least one end user.
15. The method of claim 14, wherein the role further includes at least one of allowing access to at least one privilege based on an end user identification, limiting access to at least one database object to at least one user.
16. The method of claim 14, wherein if the match results do not match, the connection is established as a non-trusted connection.
Description
FIELD OF THE INVENTION

The present invention relates to connections between servers and more particularly to a method for providing a trusted context between servers.

BACKGROUND OF THE INVENTION

FIG. 1 depicts a conventional system 10 for allowing end users to access data through a data server. The conventional system 10 includes a conventional middleware server 20, a conventional data server 40, a database 50, and a network 30 connecting the conventional middleware server 20 to the conventional data server 40. End users (not shown) can connect to the conventional middleware server 20, and thus the data server 40, through clients 22, and 24.

FIG. 2 depicts a conventional method 60 for accessing data in the database 50. The conventional method 50 commences after an end user logs onto the conventional middleware server 40. The conventional middleware server 20 requests a connection with the conventional data server 40, via step 62. To do so, the conventional middleware server 20 provides the conventional data server 40 with a user identification for the conventional middleware server 20. The conventional data server 40 validates this user identification for the conventional middleware server 20, via step 64. If the conventional middleware server is authorized to connect to the conventional data server 40, then a connection is established, via step 66. Using this connection, the database 50 can be accessed through the conventional middleware server 20 and returned to end users, via step 68. The connection may be terminated at the end of the session, via step 70.

Although the conventional system 10 and method 60 function, one of ordinary skill in the art will readily recognize that there are significant drawbacks. The use of the database 50 is managed through the connection between the conventional data server 40 and the conventional middleware server 20 established in step 66. However, this connection is established based on the user identification for the conventional middleware server 20. The identity of the end user that is utilizing the database 50 is not tracked. Consequently, there is a loss of end user accountability. Furthermore, because access to the database 50 is managed based upon the user identification of the conventional middleware server 20, that middleware server user ID identification is granted all the privileges required for the actions of all of the end users connecting to the database 50 through the conventional middleware server 20. This results in weakened security since because every end user has access to the same set of privileges on the database 40. For example, all end users of the conventional middleware server 20 may access the same data on the database 40 even though the end user IDs themselves may not otherwise be authorized to access the data. Security for the database 50 is thereby weakened. Alternatively, each time a new end user accesses the database 40 through the conventional middleware server 20, the connection between the conventional middleware server 20 and the data server 40 is re-established based on the identification of the end user. The method 60 is thus repeated and the conventional middleware server 20 re-authenticated each time a new end user desires access to the database 50. Providing new connections for each end user ameliorates the weakening of security discussed above. Furthermore, the connection may allow the end user to obtain only those privileges to which the end user is entitled. However, overhead is greatly increased and performance suffers significantly.

Accordingly, what is needed is an improved mechanism for managing connections between a middleware server and a data server. The present invention addresses such a need.

BRIEF SUMMARY OF THE INVENTION

The present invention provides a method for establishing a connection between a data server and a middleware server is disclosed. The method comprises defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes provided in a connection request. The method also comprises establishing the trusted context based on the validating the plurality of trust attributes.

According to the method disclosed herein, the present invention allows a trusted connection to be established and aspects of the relationships between the middleware server, data server, and/or end users managed using roles.

BRIEF DESCRIPTION OF SEVERAL VIEWS OF THE DRAWINGS

FIG. 1 is a diagram of a conventional system that can be used to access a database.

FIG. 2 depicts a conventional method for accessing a database through a middleware server and data server.

FIG. 3 is a block diagram depicting one embodiment of a computer system in accordance with the present invention that provides a trusted context for connecting between a middleware server and a data server.

FIG. 4 is a high-level flow chart depicting one embodiment of a method in accordance with the present invention for establishing and using a trusted context for a middleware server and a data server.

FIG. 5 is a more detailed flow chart depicting one embodiment of a method in accordance with the present invention for establishing and using a trusted context for a middleware server and a data server.

DETAILED DESCRIPTION OF THE INVENTION

The present invention relates to computer systems. The following description is presented to enable one of ordinary skill in the art to make and use the invention and is provided in the context of a patent application and its requirements. Various modifications to the preferred embodiments and the generic principles and features described herein will be readily apparent to those skilled in the art. Thus, the present invention is not intended to be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and features described herein.

The present invention provides a method for establishing a connection between a data server and a middleware server is disclosed. The method comprises defining a plurality of trust attributes corresponding to a trusted context between the middleware server and the data server and validating the plurality of trust attributes against a plurality of attributes corresponding to the middleware server. The plurality of attributes are provided directly or indirectly in a connection request. The method also comprises establishing the trusted context based on the validating the plurality of trust attributes.

The present invention will be described in terms of a particular data servers, middleware servers, and networks. However, one of ordinary skill in the art will readily recognize that the method can operate for other servers, middleware servers and networks having other and/or additional components and which are connected in a different manner not inconsistent with the present invention.

FIG. 3 is a block diagram depicting one embodiment of a system 100 in accordance with the present invention that provides a trusted context for connecting between a middleware server and a data server. The system 100 includes a middleware server 120 connected to a data server 140 through a network 130. The middleware server 120 is connected to clients 122 and 124, which may be utilized by end users to connect to the middleware server 120. The middleware server 120 also preferably includes code 126 used in creating a trusted context. The code 126 may allow the middleware server 120 to request the connection, request that the connection be made as a trusted context if desired, and a mechanism for exchanging information relating to the trusted context, such as tokens relating to the trusted context (described below) that may be passed between the middleware server 120 and data server 140, as well as APIs used in establishing the trusted context.

The data server 140 is coupled with a database 150 and manages access to the database 150. The data server 140 includes code 180 for managing connections with the middleware server 120. The code 180 includes a validation block 182 and a connection block 184. The validation block 182 is used to validate attributes of the middleware server. The connection block 184 can be used to manage other aspects of establishing a connection in accordance with the present invention between the middleware server 120 and the data server 140. Note that the code 180 may include a different arrangement of components 182 and 184 in order to perform the desired functions, as well as other and/or additional components. The data server 140 also includes data 160 and 170 corresponding to trusted connections. At least one of the data 160 and 170 corresponds to a trusted connection established between the middleware server 120 and the data server 140. The data 160 and 170 includes trusted attributes 162 and 172, respectively, and may include roles 164 and 174, respectively, for the corresponding connection. Note that although roles 164 and 174 are described as being associated with a user within a particular trusted context, they can be associated either to all users of the trusted context level or to a specific user within the context. In such an embodiment, individual users can obtain additional privileges using the role, but only through the trusted context. This prevents end users from accessing objects outside of the protected middleware server 120 through the role when connecting to the database 150 outside of the trusted context.

The system 100 can create a trusted context between the middleware server 120 and the data server 140. A trusted context is one which is believed to be secure for at least some purpose and is a candidate for re-use with or without re-authentication of the end user.

Trusted attributes 162 and 172 are used to determine whether a particular request for a connection is a candidate for a trusted context. In one embodiment, only requests asking for a trusted context would be candidates for a trusted context. In another embodiment, any request from the middleware server 120 is a candidate for a trusted context. Examples of trusted attributes 162 and 172 include but are not limited to the user identification for the middleware server 120, attributes of the specific connection that can be trusted such as the system authorization id, encryption, authentication, protocol and job name, as well as the IP address of or domain name for the middleware server connection to the data server 140. In an alternate embodiment, attributes of the client 122 or 124 using the connection might be a trusted attribute 162 or 172, such as the IP address of the client 122 or 124. In such an embodiment, the middleware server 120 would provide the identity of the client 122 or 124. For example, trusted attributes 162 or 172 may take the form: SYSTEM AUTHID WASADMI; Address 9.26.113.204, Address 9.26.113.208, and Address 9.26.113.219. Such trusted attributes 162 or 172 can be used to validate creation of a trusted context for a middleware server having a user identification WASADMI, for connections having addresses 9.26.113.204, and 9.26.113.218.

Roles 164 and 174 can be used to manage aspects, such as privileges granted, of a trusted connection. Examples of analogous roles can be found SQL. For example, access to database objects of the database 150, authorization of end users, and other privileges granted to end users may be managed through the use of roles. A role 164 and/or 174 could encompass all end users in the trusted context. For such a role 164 or 174, any privilege granted to the role 164 or 174 would be granted to the end user. A role 164 and/or 174 could also be associated with individual end users or subsets of the end users of the trusted context. For such a role 164 or 174, only the associated the end user(s) would inherit the privileges of the role 164 or 174. Such roles 164 and 174 may thus include data related not only to the privileges granted, but information, such as end user identification, required for the privilege to be granted. Such roles 164 or 174 would also override relevant defaults for the trusted context, replacing the appropriate defaults with rules for the roles 164 and 174. Thus, the roles 164 and 174 allow the trusted context to be managed at a finer level.

FIG. 4 is a high-level flow chart depicting one embodiment of a method 200 in accordance with the present invention for establishing and using a trusted context for a middleware server 120 and a data server 140. For clarity, the method 200 is described in the context of the system 100. However the method 200 might be used with another system (not shown). Thus, the method 200 is described in the context of a connection between the middleware server 120 and the data server 140. It is also presumed that the data 160 corresponds to the trusted context.

Data 160 for the trusted context is defined, via step 202. Step 202 includes defining the trust attributes 162. Step 202 is preferably performed by a database administrator (not shown) having the authority to define trusted contexts for the data server 140. In one embodiment, step 202 may include defining any roles 164, if any, associated with the trusted context as a whole and/or to individual end users within that context. However, at least the trust attributes are defined. Attributes of the middleware server 120 are validated against the trust attributes 162, via step 204. Step 204 is preferably performed in response to a request for a connection from the middleware server 120. The request for the connection would include attributes of the middleware server 120, such as the address and user identification of the middleware server. In one embodiment, the middleware server 120 can provide additional information in the request, such as attributes of the client 122 or 124 and/or attributes of the end user. The trusted connection may then be established based upon the results of the validation, via step 206. In one embodiment, if the attributes match the trust attributes, then the trusted connection is established in step 204. If the attributes do not match the trust attributes, then in one embodiment, a connection that is not trusted could be established or an error message could be provided and the connection suspended.

Using the method 200, a trusted connection may be established. Such a connection might be reused and user privileges may be managed with a finer granularity. For example, end user(s) may be required to input their user identification before using the trusted context. In addition, access to certain database objects, such authorized users, and other features of the trusted connection may be validated. Consequently, security and performance may be improved.

FIG. 5 is a more detailed flow chart depicting one embodiment of a method 250 in accordance with the present invention for establishing and using a trusted context for a middleware server 120 and a data server 140. For clarity, the method 250 is described in the context of the system 100. However the method 250 might be used with another system (not shown). Thus, the method 250 is described in the context of a connection between the middleware server 120 and the data server 140. It is also presumed that the data 160 corresponds to the trusted context.

Data 160 for the trusted context is defined, via step 252. Step 252 includes defining the trust attributes 162. Step 252 is preferably performed by a database administrator (not shown) having the authority to define trusted contexts for the data server 140. In one embodiment, step 252 may include defining any roles 164, if any, associated with the trusted context as a whole and/or for individual end users within the context.

A request for connection is made by the middleware server 120, via step 254. Step 254 includes the middleware server 120 providing the appropriate attributes for validation. The attributes of the middleware server 120 may include such as the address and user identification of the middleware server. In one embodiment, additional information such as attributes of the client 122 or 124, such as their addresses, or attributes of the end user such as their user identification, might be provided by the middleware server 120 in the request.

In response to the request for a connection from the middleware server 120, the attributes of the middleware server 120 are validated against the trust attributes 162, via step 256. Step 256 is performed by the data server 140. If the attributes of the middleware server 120 match the trust attributes 162, then the connection having the trusted context is established, via step 258. If the attributes do not match the trust attributes, then in one embodiment, a connection that is not trusted could be established or an error message could be provided and the connection suspended. Once the connection having the trusted context is established, the connection is managed based upon the trusted context, via step 260. In particular, step 260 utilizes the roles 164 and other data 160 to manage the trusted context. For example, access to certain data objects of the database 160 may be restricted for certain end users. Some or all of the users may also be able to reuse the connection with or without re-authentication. Moreover, the trusted context may have a time limit. In such an embodiment, step 260 would include terminating the connection after the time limit expires.

Using the method 250, a trusted connection may be established. Such a connection might be reused and user privileges may be managed with a finer granularity. For example, end user(s) may be required to input their user identification before using the trusted context. In addition, access to certain database objects, such authorized users, and other features of the trusted connection may be validated. Consequently, security and performance may be improved.

A method for providing a trusted context has been disclosed. The present invention has been described in accordance with the embodiments shown, and one of ordinary skill in the art will readily recognize that there could be variations to the embodiments, and any variations would be within the spirit and scope of the present invention. Software written according to the present invention is to be stored in some form of computer-readable medium, such as memory, CD-ROM or transmitted over a network, and executed by a processor. Consequently, a computer-readable medium is intended to include a computer readable signal which, for example, may be transmitted over a network. Accordingly, many modifications may be made by one of ordinary skill in the art without departing from the spirit and scope of the appended claims.

Patent Citations
Cited PatentFiling datePublication dateApplicantTitle
US5586260Feb 12, 1993Dec 17, 1996Digital Equipment CorporationMethod and apparatus for authenticating a client to a server in computer systems which support different security mechanisms
US5598536Aug 9, 1994Jan 28, 1997Shiva CorporationApparatus and method for providing remote users with the same unique IP address upon each network access
US5619657Jun 6, 1994Apr 8, 1997Digital Equipment CorporationMethod for providing a security facility for a network of management servers utilizing a database of trust relations to verify mutual trust relations between management servers
US5841869Aug 23, 1996Nov 24, 1998Cheyenne Property TrustMethod and apparatus for trusted processing
US6052785Nov 21, 1997Apr 18, 2000International Business Machines CorporationMultiple remote data access security mechanism for multitiered internet computer networks
US6076092Aug 19, 1997Jun 13, 2000Sun Microsystems, Inc.System and process for providing improved database interfacing using query objects
US6112196Jun 25, 1998Aug 29, 2000International Business Machines CorporationMethod and system for managing connections to a database management system by reusing connections to a database subsystem
US6212636May 1, 1997Apr 3, 2001Itt Manufacturing EnterprisesMethod for establishing trust in a computer network via association
US6266666Sep 8, 1998Jul 24, 2001Sybase, Inc.Component transaction server for developing and deploying transaction- intensive business applications
US6286104 *Aug 4, 1999Sep 4, 2001Oracle CorporationAuthentication and authorization in a multi-tier relational database management system
US6349338Mar 2, 1999Feb 19, 2002International Business Machines CorporationTrust negotiation in a client/server data processing network using automatic incremental credential disclosure
US6377994Apr 15, 1996Apr 23, 2002International Business Machines CorporationMethod and apparatus for controlling server access to a resource in a client/server system
US6434543Nov 1, 1999Aug 13, 2002Sun Microsystems, Inc.System and method for reliable caching of database connections in a distributed application
US6516416Jun 11, 1997Feb 4, 2003Prism ResourcesSubscription access system for use with an untrusted network
US6631371Sep 18, 2002Oct 7, 2003Oracle International CorporationDatabase fine-grained access control
US6745332Jun 29, 1999Jun 1, 2004Oracle International CorporationMethod and apparatus for enabling database privileges
US7174565Dec 16, 2005Feb 6, 2007Microsoft CorporationNegotiating secure connections through a proxy server
US7181764Oct 28, 2004Feb 20, 2007Yahoo! Inc.System and method for a subscription model trusted email database for use in antispam
US7325246Jan 7, 2002Jan 29, 2008Cisco Technology, Inc.Enhanced trust relationship in an IEEE 802.1x network
US20020016777Mar 7, 2001Feb 7, 2002International Business Machines CorporationAutomated trust negotiation
US20020049914Oct 25, 2001Apr 25, 2002Kabushiki Kaisha ToshibaElectronic service system using safe user information management scheme
US20020065956May 11, 2001May 30, 2002Yuichi YagawaSecure multi database system
US20020184217Apr 19, 2001Dec 5, 2002Bisbee Stephen F.Systems and methods for state-less authentication
US20030014527Mar 13, 2002Jan 16, 2003Terwindt Johannes Gerardus HendricusSystem for registering a recordable medium, system for authenticating a recordable medium, as well as servers and a client system for such systems
US20030236975Jun 20, 2002Dec 25, 2003International Business Machines CorporationSystem and method for improved electronic security credentials
US20040064335Sep 5, 2003Apr 1, 2004Yinan YangMethod and apparatus for evaluating trust and transitivity of trust of online services
US20040199922 *Jan 2, 2004Oct 7, 2004Krutsch Kenneth F.Productivity application management
US20060075075 *Oct 1, 2004Apr 6, 2006Malinen Jouni IMethod and system to contextually initiate synchronization services on mobile terminals in an enterprise environment
Non-Patent Citations
Reference
1Chadwick, et al., "Role-Based Access Control With X.509 Attribute Certificates," IEEE Internet Computing 7.2. Mar. 2003, pp. 62-69.
2Kristol, et al., "HTTP State Management Mechanism," 1997, RFC Editor.
3Park, et al., "Secure Cookies on the Web," Jul. 2000, IEEE Internet Computing 4.4, pp. 36-44.
4Paul M. Bird, et al. Method, System And Program For Establishing A Trusted Relationship Between A Data Server And A Middleware Server. U.S. Appl. No. 11/008,507.
5U.S. Appl. No. 11/008,507, filed Dec. 8, 2004, titled Method, System and Program for Establishing a Trusted Relationship Between a Data Server and a Middleware Server.
Classifications
U.S. Classification709/229, 726/3, 726/12, 709/204, 709/205, 709/207, 709/206, 726/1, 713/151
International ClassificationG06F21/00
Cooperative ClassificationH04L63/08, H04L63/102
European ClassificationH04L63/08
Legal Events
DateCodeEventDescription
Jun 28, 2013FPAYFee payment
Year of fee payment: 4
Jun 28, 2013SULPSurcharge for late payment
Mar 11, 2013REMIMaintenance fee reminder mailed
Mar 17, 2005ASAssignment
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:BIRD, PAUL M.;CHANDRAN, GAYATHIRI R.;COTNER, CURT L.;ANDOTHERS;REEL/FRAME:015920/0321;SIGNING DATES FROM 20050302 TO 20050309