CN111125130A - Account type analysis method, system and storage medium oriented to Dameng database - Google Patents
Account type analysis method, system and storage medium oriented to Dameng database Download PDFInfo
- Publication number
- CN111125130A CN111125130A CN201911271013.1A CN201911271013A CN111125130A CN 111125130 A CN111125130 A CN 111125130A CN 201911271013 A CN201911271013 A CN 201911271013A CN 111125130 A CN111125130 A CN 111125130A
- Authority
- CN
- China
- Prior art keywords
- account
- time information
- database
- host
- type analysis
- 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.)
- Granted
Links
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3438—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment monitoring of user actions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computer Hardware Design (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- General Health & Medical Sciences (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- Quality & Reliability (AREA)
- Computational Linguistics (AREA)
- Debugging And Monitoring (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses an account type analysis method facing a Dameng database, which analyzes login information of each account logged in the Dameng database, generates account logs and account type analysis, automatically monitors the accounts, and automatically disables the accounts when the login times of a certain account is less than or equal to a set value so as to improve the use efficiency and reduce the cost; the invention also discloses an account type analysis system and a storage medium for the Daemon database, which analyze the login information of each account logged into the Daemon database, generate an account log and account type analysis, automatically monitor the account, and automatically disable the account when the login times of a certain account are less than or equal to a set value, so as to improve the use efficiency and reduce the cost.
Description
[ technical field ] A method for producing a semiconductor device
The invention relates to an account type analysis method, system and storage medium for a Daemon database.
[ background of the invention ]
With the increasing sophistication of the dreams database, more and more companies choose the dreams database as their database. In order to ensure the safety of the database, when people flow, an administrator is required to manually disable the related account. Due to various reasons such as information asymmetry, a database administrator cannot timely know the change information of personnel, so that a large number of overdue accounts needing to be forbidden exist in the database, and great influence is brought to the safety of the database
The invention is researched and proposed aiming at the defects of the prior art.
[ summary of the invention ]
The invention aims to provide an account type analysis method, system and storage medium for a Daemon database, so as to manage accounts logged into the Daemon database and save resources.
In order to solve the technical problem, the invention provides an account type analysis method facing a dream database, which comprises the following steps:
s101, operating a host to log in a dream database and acquiring management authority;
s102, acquiring time information recorded in the Dameng database when an account logs into the Dameng database last time, storing the account information and the corresponding time information into an operation host, and generating account log and account type analysis of each account;
s103, automatically inquiring the time information of the user account which is logged into the dream database last time every other day;
s104, comparing the latest time information of the same inquired account with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two pieces of time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, updating basic information and authority information of each account, and recording the basic information and the authority information into an account log and account type analysis;
s105, the operation host judges whether the total login times of the same account in a continuous timing period are smaller than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
In the above-mentioned account type analysis method for the dream database, in step S103, the time information of the user account that has logged into the dream database last time is automatically queried every other day.
In step S105, if the operation host determines that the total number of logins of the same account in the timing period is equal to zero in the timing period which is continuous and has a time length of 30 days, the operation host automatically disables the account and updates the account type analysis of each account.
The above-mentioned account type analysis method for a dreams database, the account log includes: host IP, account name, last login time, whether authority is changed, operation and editing.
The above-mentioned account type analysis method for a dreams database includes: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing.
The invention relates to an account type analysis system facing a Dameng database, which comprises:
the login module is used for operating the host to login the dream database;
the data processing module is used for acquiring the time information of the last login of the account into the dream database, which is recorded in the dream database, and storing the account information and the corresponding time information into the operation host to generate an account log and account type analysis of each account;
the query module is used for automatically querying the time information of the latest login dreaming database of the user account every other day;
the comparison module is used for comparing the latest time information of the same inquired account with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two pieces of time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, and updating account logs and account type analysis of each account; and the number of the first and second groups,
the account number forbidding module is used for judging whether the total login times of the same account number in a continuous timing period is less than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
The above-mentioned account type analysis system facing to dreams database, the account log includes: host IP, account name, last login time, whether authority is changed, operation and editing.
The above-mentioned account type analysis system for a dreams database includes: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing.
A storage medium of the present invention stores a computer program that implements the account type analysis method according to any one of claims 1 to 5.
Compared with the prior art, the invention has the following advantages:
1. according to the method and the system, the login information of each account logged into the dream database is analyzed, account logs and account type analysis are generated, the accounts are automatically monitored, and when the login times of a certain account are smaller than or equal to a set value, the account is automatically forbidden, so that the use efficiency is improved, and the cost is reduced.
[ description of the drawings ]
The following detailed description of embodiments of the invention is provided in conjunction with the appended drawings, in which:
FIG. 1 is a flowchart of an account type analysis method according to the present invention;
FIG. 2 is one of the operational screenshots of "Account type analysis" in the present invention;
FIG. 3 is a second screenshot of the "Account type analysis" run in accordance with the present invention;
FIG. 4 is one of the operational screenshots of the "Account Log" of the present invention;
fig. 5 is a second operation screenshot of "account log" in the present invention.
[ detailed description ] embodiments
Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.
As shown in fig. 1 to 5, the method for analyzing account types oriented to a dreams database of the present embodiment includes the following steps:
s101, operating a host to log in a dream database and acquiring management authority;
s102, acquiring time information recorded in the Dameng database when an account logs into the Dameng database last time, storing the account information and the corresponding time information into an operation host, and generating account log and account type analysis of each account;
s103, automatically inquiring the time information of the user account which is logged into the dream database last time every other day;
s104, comparing the latest time information of the same account which is inquired with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, updating basic information and authority information of each account, analyzing each account type according to a table for recording login time, and performing corresponding processing;
s105, the operation host judges whether the total login times of the same account in a continuous timing period are smaller than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
According to the method and the system, the login information of each account logged into the dream database is analyzed, account logs and account type analysis are generated, the accounts are automatically monitored, and when the login times of a certain account are smaller than or equal to a set value, the account is automatically forbidden, so that the use efficiency is improved, and the cost is reduced.
In the present embodiment, in step S103, the time information of the user account that has logged into the dream database last time is automatically queried every other day, and the time information is automatically queried every other 5 minutes, so that missing detection can be prevented, and occupation of system resources can be saved.
In this embodiment, in step S105, if the operating host determines that the total number of logins of the same account in the timing period is equal to zero in the timing period which is continuous and has a time length of 30 days, the operating host automatically disables the account and updates the account type analysis of each account.
As shown in fig. 4 and 5, in this embodiment, the account log includes: host IP, account name, last login time, whether authority is changed, operation and editing; the operator can check the state of the account through the account log and operate the account at the same time.
As shown in fig. 2 and 3, the account type analysis includes: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing; the operator can analyze and check the state of the account through the account type and operate the account at the same time.
An account type analysis system for a dreams database of this embodiment includes:
the login module is used for operating the host to login the dreaming database, and mainly executes a dreaming command for acquiring account information by remotely logging in the dreaming database of the target machine through an ansable to acquire corresponding data;
the data processing module is used for acquiring the time information of the last login of the account into the dream database, which is recorded in the dream database, and storing the account information and the corresponding time information into the operation host to generate an account log and account type analysis of each account;
the query module is used for automatically querying the time information of the latest login of the user account into the dream database every 4-6 minutes;
the comparison module is used for comparing the latest time information of the same inquired account with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two pieces of time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, and updating account logs and account type analysis of each account; and the number of the first and second groups,
the account number forbidding module is used for judging whether the total login times of the same account number in a continuous timing period is less than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
In this embodiment, the account log includes: host IP, account name, last login time, whether authority is changed, operation and editing.
In this embodiment, the account type analysis includes: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing.
A storage medium of the present embodiment, which stores a computer program for implementing the account type analysis method according to any one of claims 1 to 5.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform. With such an understanding in mind, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (9)
1. An account type analysis method oriented to a Dameng database is characterized by comprising the following steps of:
s101, operating a host to log in a dream database and acquiring management authority;
s102, acquiring time information recorded in the Dameng database when an account logs into the Dameng database last time, storing the account information and the corresponding time information into an operation host, and generating account log and account type analysis of each account;
s103, automatically inquiring the time information of the user account which is logged into the dream database last time every other day;
s104, comparing the latest time information of the same inquired account with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two pieces of time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, updating basic information and authority information of each account, and recording the basic information and the authority information into an account log and account type analysis;
s105, the operation host judges whether the total login times of the same account in a continuous timing period are smaller than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
2. The method for analyzing account types in database for dream reaching, as claimed in claim 1, wherein in step S103, the time information of the user account last logging in database for dream reaching is automatically queried every other day.
3. The method as claimed in claim 1, wherein in step S105, if the host determines that the total number of logins of the same account in the timing period is equal to zero in a continuous timing period with a duration of 30 days, the host automatically disables the account and updates the account type analysis of each account.
4. The account type analysis method for Daemon database according to claim 1, wherein the account log comprises: host IP, account name, last login time, whether authority is changed, operation and editing.
5. The account type analysis method for dacomig database according to claim 1, wherein the account type analysis comprises: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing.
6. An account type analysis system oriented to a Dameng database, comprising:
the login module is used for operating the host to login the dream database;
the data processing module is used for acquiring the time information of the last login of the account into the dream database, which is recorded in the dream database, and storing the account information and the corresponding time information into the operation host to generate an account log and account type analysis of each account;
the query module is used for automatically querying the time information of the latest login of the user account into the dream database every 4-6 minutes;
the comparison module is used for comparing the latest time information of the same inquired account with the last recorded time information stored in the operation host;
if the two time information are the same, the operation is not carried out;
if the two pieces of time information are different, updating the time information stored by the operation host, executing +1 login times of the account, storing the updated time information and login times of the account into the operation host, and updating account logs and account type analysis of each account; and the number of the first and second groups,
the account number forbidding module is used for judging whether the total login times of the same account number in a continuous timing period is less than a set value or not;
if the number of login times of the account is less than or equal to a set value, the operation host automatically disables the account, and meanwhile updates account logs and account type analysis of each account;
and if the login times of the account are greater than the set value, not performing operation.
7. The system of claim 1, wherein the account log comprises: host IP, account name, last login time, whether authority is changed, operation and editing.
8. The system of claim 1, wherein the account type analysis comprises: resource type, host IP, account number, last login time, account number type, account number state, forbidden or starting, operating and editing.
9. A storage medium characterized by storing a computer program that implements the account type analysis method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911271013.1A CN111125130B (en) | 2019-12-12 | 2019-12-12 | Account type analysis method, system and storage medium for dream database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911271013.1A CN111125130B (en) | 2019-12-12 | 2019-12-12 | Account type analysis method, system and storage medium for dream database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111125130A true CN111125130A (en) | 2020-05-08 |
| CN111125130B CN111125130B (en) | 2023-06-13 |
Family
ID=70499534
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911271013.1A Active CN111125130B (en) | 2019-12-12 | 2019-12-12 | Account type analysis method, system and storage medium for dream database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111125130B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108449327A (en) * | 2018-02-27 | 2018-08-24 | 平安科技（深圳）有限公司 | A kind of account method for cleaning, device, terminal device and storage medium |
| CN109902079A (en) * | 2019-02-21 | 2019-06-18 | 广东电网有限责任公司信息中心 | A method of for reaching the automatic safe management of dream database |
-
2019
- 2019-12-12 CN CN201911271013.1A patent/CN111125130B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108449327A (en) * | 2018-02-27 | 2018-08-24 | 平安科技（深圳）有限公司 | A kind of account method for cleaning, device, terminal device and storage medium |
| CN109902079A (en) * | 2019-02-21 | 2019-06-18 | 广东电网有限责任公司信息中心 | A method of for reaching the automatic safe management of dream database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111125130B (en) | 2023-06-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107678907B (en) | Database service logic monitoring method, system and storage medium | |
| CN104717085B (en) | A kind of daily record analysis method and device | |
| CN107451040B (en) | Method and device for positioning fault reason and computer readable storage medium | |
| CN103023984B (en) | Terminal application server and application log filtering method thereof | |
| CN109543891B (en) | Method and apparatus for establishing capacity prediction model, and computer-readable storage medium | |
| CN113656245B (en) | Data inspection method and device, storage medium and processor | |
| US9256827B2 (en) | Portable data management using rule definitions | |
| US20120254337A1 (en) | Mainframe Management Console Monitoring | |
| CN110096419A (en) | Acquisition methods, interface log management server and the service server of interface log | |
| US20120254416A1 (en) | Mainframe Event Correlation | |
| CN108052358B (en) | Distributed deployment system and method | |
| US8738768B2 (en) | Multiple destinations for mainframe event monitoring | |
| CN109254912A (en) | A kind of method and device of automatic test | |
| CN113836237A (en) | Method and device for auditing data operation of database | |
| CN110941632A (en) | Database auditing method, device and equipment | |
| CN112882927A (en) | Interface automatic testing method, device, equipment and medium | |
| CN104636244A (en) | Server monitoring method using Java, MySQL and Shell | |
| CN113419935A (en) | Mobile terminal performance monitoring method, device, equipment and storage medium | |
| CN108650123B (en) | Fault information recording method, device, equipment and storage medium | |
| KR100906454B1 (en) | Database log data management apparatus and method thereof | |
| CN115033639A (en) | Method and related device for generating relation graph for data sharing among clusters | |
| CN111885088A (en) | Log monitoring method and device based on block chain | |
| CN111752838A (en) | Question checking method and device, server and storage medium | |
| CN111125130A (en) | Account type analysis method, system and storage medium oriented to Dameng database | |
| CN113472881B (en) | Statistical method and device for online terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |