CN104965870A - Method for managing and comparing authority data of large-scale enterprise information system - Google Patents

Method for managing and comparing authority data of large-scale enterprise information system Download PDF

Info

Publication number
CN104965870A
CN104965870A CN201510313780.XA CN201510313780A CN104965870A CN 104965870 A CN104965870 A CN 104965870A CN 201510313780 A CN201510313780 A CN 201510313780A CN 104965870 A CN104965870 A CN 104965870A
Authority
CN
China
Prior art keywords
data
authority
service application
step
stage
Prior art date
Application number
CN201510313780.XA
Other languages
Chinese (zh)
Inventor
高超
尚博祥
孙轶凡
翟玮
孟凡禹
Original Assignee
国网天津市电力公司
国家电网公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 国网天津市电力公司, 国家电网公司 filed Critical 国网天津市电力公司
Priority to CN201510313780.XA priority Critical patent/CN104965870A/en
Publication of CN104965870A publication Critical patent/CN104965870A/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/903Querying
    • G06F16/9032Query formulation

Abstract

A method for managing and comparing authority data of a large-scale enterprise information system. The method for managing and comparing the authority data of the large-scale enterprise information system comprises the steps of: configuring a production environment comprising a uniform authority platform and each service application system database address; configuring each authority data of a service application which needs to be inquired and an inquiry authority data SQL sentence of the corresponding service application in the uniform authority platform; configuring a redundant data SQL sentence which comprises a total volume of data and a redundant data inquiry SQL; executing the operation of comparing authority data accessed into the uniform authority platform with the authority data of the service application and inquiring a comparison result; viewing the redundant data in the uniform authority platform; and inquiring a historical difference comparison result and inquiring specific different data and the like. According to the present invention, the different data of both parties of the system can be viewed in real time and the historical different data is provided for inquiry, so that quality of the authority data management work is greatly promoted.

Description

A kind of large enterprise infosystem permissions data management comparison method

Technical field

The invention belongs to Enterprise Informatization Technology field, particularly relate to a kind of large enterprise infosystem permissions data management comparison method.

Background technology

Electric system unified rights platform is since in July, 14 reaches the standard grade, access multiple system successively, when formally entering the system cloud gray model stage, carry out in management process, finding that part system is carrying out occurring synchronization failure when authority is synchronous, causes system both sides to there are differences data to permissions data.Synchronization failure reason is cause because application system organizational structure and unified rights organizational structure are also not completely the same according to analysis, this part historical reasons also cannot be corrected temporarily, so need to manage and comparison intrasystem permissions data, but still lack such method at present.

Summary of the invention

In order to solve the problem, the object of the present invention is to provide a kind of large enterprise infosystem permissions data management comparison method.

In order to achieve the above object, large enterprise provided by the invention infosystem permissions data management comparison method comprises the following step performed in order:

Step one, configure S01 stage of each service application database address: configuration comprises unified rights platform production environment and each business application system database address;

Step 2, configure S02 stage of each business application system permissions data query statement: configuration needs the search access right data SQL statement of corresponding service application in each permissions data of the service application of inquiry and unified rights platform;

The S03 stage of step 3, the inquiry of configuration unified rights redundant data: configuring redundancy data SQL statement, comprises data count and redundant data query SQL;

Step 4, perform contrast operation the S04 stage of Query Result: the comparison of the permissions data and service application permissions data that perform the access of unified rights platform operates, and inquires comparison result;

Step 5, check S05 stage of redundant data: check the redundant data in unified rights platform;

Step 6, check S06 stage of historical difference data: query history difference comparison result, and concrete variance data can be inquired.

The effect of large enterprise provided by the invention infosystem permissions data management comparison method:

Can real time inspection system both sides variance data, and historical difference data query is provided, greatly improve the quality of permissions data management work.

Accompanying drawing explanation

Fig. 1 is large enterprise provided by the invention infosystem permissions data management comparison method process flow diagram.

Embodiment

Below in conjunction with the drawings and specific embodiments, large enterprise provided by the invention infosystem permissions data management comparison method is described in detail.

As shown in Figure 1, large enterprise provided by the invention infosystem permissions data management comparison method comprises the following step performed in order:

Step one, configure S01 stage of each service application database address: configuration comprises unified rights platform production environment and each business application system database address;

Step 2, configure S02 stage of each business application system permissions data query statement: configuration needs the search access right data SQL statement of corresponding service application in each permissions data of the service application of inquiry and unified rights platform;

The S03 stage of step 3, the inquiry of configuration unified rights redundant data: configuring redundancy data SQL statement, comprises data count and redundant data query SQL;

Step 4, perform contrast operation the S04 stage of Query Result: the comparison of the permissions data and service application permissions data that perform the access of unified rights platform operates, and inquires comparison result;

Step 5, check S05 stage of redundant data: check the redundant data in unified rights platform;

Step 6, check S06 stage of historical difference data: query history difference comparison result, and concrete variance data can be inquired.

Large enterprise provided by the invention infosystem permissions data management comparison method is utilized to carry out the concrete thought of permissions data comparison as follows:

Use management person's login system, and configure unified rights platform and each operation system database address in operation system configuration menu under system configuration, set up DBLINK, realize each operation system database link;

In service application configuration, add the permissions data query SQL statement that each business application system provides; Comprising concrete power limit data such as business roles, organizational roles, user, tissue, menu, resources; The query statement of redundant data is added in redundant data SQL config option under system configuration, comprise the redundant queries of the categorical datas such as business roles, organizational roles, menu, resource, user, tissue, role's resources relationship, user role relation, Query Result comprises total number and the redundant data number of all types of data;

In unified rights Data Detection menu under data detection module, by performing contrast operation, realize the permissions data comparison between unified rights platform and service application, after prompting comparison terminates, by carrying out the variance data of inquiring about the same day option date; And comparison result will be preserved in a database, after being provided with, carry out the inquiry of historical data.In the variance data inquired, can intuitively arrive difference number, click difference number and can check variance data details.When carrying out permissions data management, can manage in unified rights platform according to the variance data inquired.Enter and check redundant data option under data monitoring, can inquire and whether there is redundant data in unified rights platform, and intuitively show the number of redundant data, by check redundant data can more convenient, easily system is rectified and improved, ensure the validity of data.System also provides the historical query of variance data, and provides export function.Enter the data check option under data monitoring, the information such as title, coding can be inquired, more easily data are checked and comparison; And Query Result can be self-defined, adapt to inquiry and the management of Various types of data.

After this method is implemented, unified rights platform project group prepares to set up permissions data administrative mechanism, notes down, after service improvement, the inconsistent anomalous event of permissions data occurs again.

This method not only notes down variance data, is also assessed by historical difference situation, to occurring that the more business application system of difference number of times is noted down.According to record, carry out the investigation of the degree of depth.Emphasis is narrowed down to " point " gradually from " face ", completely data inconsistence problems is solved.And managed by effective permissions data, the permissions data in maintenance service application system and unified rights platform, prevents the generation again of problem.

Large enterprise provided by the invention infosystem permissions data management comparison method is the permissions data comparison instrument in the permissions data and service application accessed in unified rights platform, not only solve the inconsistent permissions data synchronization failure problem caused with each operation system both data, also lay good basis for Utilities Electric Co.'s System right management and information environment framework.

Claims (1)

1. large enterprise's infosystem permissions data management comparison method, is characterized in that: it comprises the following step performed in order:
Step one, configure S01 stage of each service application database address: configuration comprises unified rights platform production environment and each business application system database address;
Step 2, configure S02 stage of each business application system permissions data query statement: configuration needs the search access right data SQL statement of corresponding service application in each permissions data of the service application of inquiry and unified rights platform;
The S03 stage of step 3, the inquiry of configuration unified rights redundant data: configuring redundancy data SQL statement, comprises data count and redundant data query SQL;
Step 4, perform contrast operation the S04 stage of Query Result: the comparison of the permissions data and service application permissions data that perform the access of unified rights platform operates, and inquires comparison result;
Step 5, check S05 stage of redundant data: check the redundant data in unified rights platform;
Step 6, check S06 stage of historical difference data: query history difference comparison result, and concrete variance data can be inquired.
CN201510313780.XA 2015-06-10 2015-06-10 Method for managing and comparing authority data of large-scale enterprise information system CN104965870A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510313780.XA CN104965870A (en) 2015-06-10 2015-06-10 Method for managing and comparing authority data of large-scale enterprise information system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510313780.XA CN104965870A (en) 2015-06-10 2015-06-10 Method for managing and comparing authority data of large-scale enterprise information system

Publications (1)

Publication Number Publication Date
CN104965870A true CN104965870A (en) 2015-10-07

Family

ID=54219907

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510313780.XA CN104965870A (en) 2015-06-10 2015-06-10 Method for managing and comparing authority data of large-scale enterprise information system

Country Status (1)

Country Link
CN (1) CN104965870A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103036855A (en) * 2011-09-29 2013-04-10 北京新媒传信科技有限公司 Achievement device and method of authority management
CN104104665A (en) * 2013-04-12 2014-10-15 同程网络科技股份有限公司 Unified authority authentication method suitable for electronic human resource management
CN104407964A (en) * 2014-12-08 2015-03-11 国家电网公司 Centralized monitoring system and method based on data center
CN104714956A (en) * 2013-12-13 2015-06-17 国家电网公司 Comparison method and device for isomerism record sets

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103036855A (en) * 2011-09-29 2013-04-10 北京新媒传信科技有限公司 Achievement device and method of authority management
CN104104665A (en) * 2013-04-12 2014-10-15 同程网络科技股份有限公司 Unified authority authentication method suitable for electronic human resource management
CN104714956A (en) * 2013-12-13 2015-06-17 国家电网公司 Comparison method and device for isomerism record sets
CN104407964A (en) * 2014-12-08 2015-03-11 国家电网公司 Centralized monitoring system and method based on data center

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
阮光册 等: "基于SQL数据库实现冗余数据的查询与删除", 《现代情报》 *

Similar Documents

Publication Publication Date Title
US20160364212A1 (en) System and Method for Generating an Application Structure for an Application in a Computerized Organization
US9594823B2 (en) Data relationships storage platform
CN105138592B (en) A kind of daily record data storage and search method based on distributed structure/architecture
US8978032B2 (en) Host naming application programming interface
US9336399B2 (en) Information asset placer
US9075788B1 (en) Account state simulation service for cloud computing environments
US8805971B1 (en) Client-specified schema extensions in cloud computing environments
US9590880B2 (en) Dynamic collection analysis and reporting of telemetry data
US20140143602A1 (en) Techniques for evaluating and managing cloud networks
US8959063B2 (en) Managing incident reports
RU2583703C2 (en) Malicious attack detection and analysis
US20180373774A1 (en) Cooperative naming for configuration items in a distributed configuration management database environment
US9152925B2 (en) Method and system for prediction and root cause recommendations of service access quality of experience issues in communication networks
US20150081701A1 (en) Systems and methods for data flow exploration
US7483898B2 (en) System and method for auditing a network
US9529989B2 (en) Access requests at IAM system implementing IAM data model
JP5964027B2 (en) System and method for business network management discovery and business network management aggregation
US10084681B2 (en) Method and system for monitoring server cluster
EP3050245B1 (en) Centralized policy management for security keys
US20110307957A1 (en) Method and System for Managing and Monitoring Continuous Improvement in Detection of Compliance Violations
DE112013000865T5 (en) Consolidate different cloud service data and behaviors based on trust relationships between cloud services
CN106294091B (en) It is a kind of to intercept method for analyzing performance and system without intrusive log
US20110296397A1 (en) Systems and methods for generating cached representations of host package inventories in remote package repositories
US20160006629A1 (en) Appliance clearinghouse with orchestrated logic fusion and data fabric - architecture, system and method
US8321549B2 (en) Action execution management for service configuration items

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20151007