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 PDFInfo
- 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
- stage
- permissions
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/9032—Query formulation
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
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
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.
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 Pending 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)
| 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 |
-
2015
- 2015-06-10 CN CN201510313780.XA patent/CN104965870A/en active Pending
Patent Citations (4)
| 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)
| Title |
|---|
| 阮光册 等: "基于SQL数据库实现冗余数据的查询与删除", 《现代情报》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11153383B2 (en) | Distributed data analysis for streaming data sources | |
| CN109492991B (en) | Intelligent integrated management system for power distribution project construction | |
| EP2675127B1 (en) | Method and device for automatically migrating system configuration item | |
| CN105631026A (en) | Security data analysis system | |
| US20140181965A1 (en) | Access Requests at IAM System Implementing IAM Data Model | |
| US9037525B2 (en) | Correlating data from multiple business processes to a business process scenario | |
| CN105119757A (en) | Method and system for operation and maintenance automation of enterprise servers | |
| US10664498B2 (en) | Interconnected graph structured database for identifying and remediating conflicts in resource deployment | |
| US9100301B2 (en) | Systems, methods, and articles of manufacture to manage alarm configurations of servers | |
| US10754901B2 (en) | Analytics of electronic content management systems using a staging area database | |
| US20140181912A1 (en) | Access Reviews at IAM System Implementing IAM Data Model | |
| US9942218B2 (en) | Automated production of certification controls by translating framework controls | |
| CN104504014A (en) | Data processing method and device based on large data platform | |
| US20230259647A1 (en) | Systems and methods for automated discovery and analysis of privileged access across multiple computing platforms | |
| WO2020028459A1 (en) | Method and system for implementing an automated data validation tool | |
| CN105095496A (en) | Method for monitoring MYSQL table space through ZABBIX | |
| US11068496B2 (en) | System and method for data management | |
| WO2015139565A1 (en) | Heterogeneous logging system management configuration | |
| US20190066012A1 (en) | Enterprise customer website | |
| CN104965870A (en) | Method for managing and comparing authority data of large-scale enterprise information system | |
| CN105871659A (en) | Monitoring method and device of newly added server | |
| KR20200072857A (en) | System and method for it infra operation and management | |
| CN107947971A (en) | A kind of collocation method of information, device and server | |
| CN114004595A (en) | Block chain-based government affair statistical information management method and system | |
| CN105701111A (en) | Data query method and apparatus |
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 |