Research And Implementation Of Login Information Synchronization For TuHa Oilfield Single Sign-On System

TuHa Oilfield Co. has many application systems at present. Many of them adopt independent authentication tactics, and the authorization to users is diverse. This brings inconvenient for users and administrators. For this reason, we develop a SSO (single sign-on) system based on B/ S architecture, in B/S pattern, the SSO system has integrated these applications. User uses his authorized applications in SSO system through Web Browser. It will enhance the usability and the administrability and the access security of TuHa Oilfield application systems.According to the system design of TuHa Oilfield SSO system, it divides into console management subsystem, application access subsystem based on the Web, password synchronization, user information synchronization, new application development interface and the private application management. The paper is primary about the research and realization of user information and password synchronization. The paper puts forward a solution for data synchronization of TuHa Oilfield SSO system, and realizes it by a windows service application.In TuHa Oilfield SSO system user's single sign-on information is managed by the AD server at Petrol and Natural Gas of China Ltd Co.'s and user login needs to be authenticated through the AD server, but the user information table is located in the Oracle database. The user information synchronization is to keep the consistency of the user information in the Oracle and that in the AD server. Firstly, research AD server, understand the structure of AD server. Secondly,...