JP4359236B2 - Management system - Google Patents

Description

The present invention relates to a management server that manages access to a database device, and relates to a technique for preventing unauthorized access related to leakage of secret information.

In recent years, leakage of confidential information such as personal information has become a social problem. The conventional security system has been mainly aimed at preventing unauthorized access by a person other than the user having access authority.

However, in fact, many malicious leaks are seen by users who have access rights. As a corporate responsibility, it is necessary to forestall a situation such as this.

Therefore, the main object of the present invention is to solve such problems and prevent unauthorized access related to leakage of secret information.

The management server according to the present invention is:
A database device that provides data to a user registered as a user, a user terminal operated by a user who uses the database device, and an administrator terminal operated by an administrator who manages the use of the database device by the user (1) A user key generation unit that generates a user key unique to a user as a pre-process for using the database device by the user. (2) User key transmission unit that transmits the generated user key to the user terminal as pre-processing for the user to use the database device. (3) Administrator-specific as pre-processing for the user to use the database device. Administrator key generation unit that generates the administrator key for the administrator (4) An administrator that transmits the generated administrator key to the administrator terminal as a pre-process for the user to use the database device Transmission unit (5) Database user registration information generation unit (6) for generating database user registration information for newly registering a user in the database device as a pre-process for the user to use the database device. As a pre-processing, the generated database user registration information is generated using the generated user key and the generated administrator key, and the user key at the time of decryption and the user key at the time of decryption are matched. Database user registration information for generating encrypted database user registration information as an encryption result by encrypting with an encryption logic that enables determination and determination of matching between the administrator key at the time of encryption and the administrator key at the time of decryption Encryption unit (7) Encryption database user registration information storage unit for storing encrypted database user registration information generated as a result of encryption 8) When the user uses the database device, an access start request receiving unit (9) that receives a request for starting access from the user terminal to the database device together with the user key from the user terminal. An administrator key receiving unit (10) that receives an administrator key from an administrator terminal when a user uses the database device, and stored in an encrypted database user registration information storage unit when the user uses the database device The user key at the time of encryption matches the user key at the time of decryption using the user key received together with the request and the received administrator key. And the decryption logic that determines whether the administrator key at the time of encryption matches the administrator key at the time of decryption. Database user registration information decoding unit for obtaining recorded information (11) When a user uses a database device, a create user who asks the database device for new user registration including database user registration information obtained as a decoding result Create user request part to send instructions.

The database user registration information decryption unit decrypts the encrypted database user registration information using the received administrator key, obtains primary decryption database user registration information as a decryption result,
The management server further includes a primary decryption database user registration information transmission unit that transmits primary decryption database user registration information obtained as a decryption result to the user terminal.

The management server further includes the following elements: (12) a database use schedule storage unit for storing a database use schedule for the user to use the database device; and (13) the user using the database device. A database use schedule end determination unit (14) for determining that the use end scheduled date and time of the user's database use schedule has passed, when the use end scheduled date and time has passed, A drop user request unit that transmits a drop user command for requesting deletion of a user registration related to a use schedule.

The management server further includes the following elements: (15) As a pre-process for the user to use the database device, the management server receives a database use schedule for the user to use the database device from the user terminal. Database utilization schedule input section (16) Database utilization schedule storage section for storing received database utilization schedule (17) As a pre-process for the user to use the database device, the database utilization schedule storage section stores the database utilization schedule storage section. A database usage schedule approval request that sends an approval request to the administrator terminal, receives the approval result from the administrator terminal, and can determine that the database usage schedule stored in the database usage schedule storage unit is approved. (18) Approved when a user uses a database device Database use determining section for determining whether a database within the available plans.

The management server further determines the database usage schedule that the user uses the database device.
It has a database use schedule storage unit that stores data in a plurality of database use units,
The user key generation unit generates a separate user key for each data usage unit,
The database user registration information generation unit generates separate database user registration information for each database usage unit,
The database user registration information encryption unit uses the separate user key together with the generated administrator key for each database usage unit, encrypts the separate database user registration information,
The database use schedule storage unit stores, as an encrypted database user registration information storage unit, encrypted database user registration information generated as an encryption result for each database usage unit,
The database user registration information decrypting unit decrypts encrypted database user registration information corresponding to a data usage unit including a current time.

The program according to the present invention is:
A database device that provides data to a user registered as a user, a user terminal operated by a user who uses the database device, and an administrator terminal operated by an administrator who manages the use of the database device by the user (1) As a pre-process for a user to use a database device, a user key unique to the user is provided. User key generation processing procedure to be generated (2) User key transmission processing procedure for transmitting the generated user key to the user terminal as pre-processing for the user to use the database device (3) The user uses the database device Administrator key generation processing procedure for generating an administrator key unique to the administrator as a pre-process to be used (4) Prior to the user using the database device As a matter of course, an administrator key transmission processing procedure for transmitting the generated administrator key to the administrator terminal (5) Database user registration information for newly registering a user in the database device as a pre-process for the user to use the database device Database user registration information generation processing procedure for generating (6) As a pre-process for the user to use the database device, the generated database user registration information is decrypted using the generated user key and the generated administrator key. Encryption logic that can determine whether the user key during encryption and user key during decryption match, and whether the administrator key during encryption and administrator key match during decryption Database user registration information encryption processing procedure for encrypting and generating encrypted database user registration information as an encryption result and storing it (7) Access start request reception processing procedure for receiving, together with the user key, a request for starting access from the user terminal to the database device when the user terminal is used (8) The user enters the database device Key reception processing procedure for receiving the administrator key from the administrator terminal when using the database (9) When the user uses the database device, the encrypted database stored in the database user registration information encryption processing procedure Using the user key received together with the request and the received administrator key to determine whether the user key at the time of encryption and the user key at the time of decryption match, Data that is decrypted by the decryption logic that determines whether the administrator key at decryption and the administrator key at decryption match, and if both match, obtains database user registration information as the decryption result Base user registration information decryption procedure (10) When a user uses a database device, a create user command for new user registration including database user registration information obtained as a decryption result is transmitted to the database device. Create user request processing procedure.

According to the present invention, a user key and an administrator key are generated as pre-processing, transmitted to the user terminal and the administrator terminal, respectively, and encrypted database user registration information is generated by encryption using these keys. When accessing the actual database, the encrypted database user registration information is decrypted using the user key and the administrator key received from the user terminal and the administrator terminal, respectively. If it is not, a new user registration is requested from the database device, so that impersonation of the user or unauthorized access by the user's own malicious intention can be prevented. Since it has a safety mechanism using the database utilization schedule, unexpected access can be eliminated.

Embodiment 1 FIG.
If a person with a certain knowledge about database operation knows user information for accessing the database (in the following example, database user name, database user password), without using a business application, In view of the fact that it is possible to directly access the database using the user information and steal secret information, the present invention dynamically changes the user information as an improvement measure.

FIG. 1 is a diagram illustrating a network environment. A database device 1, a management server 2, an administrator terminal 3, and a user terminal 4 are connected to a local area network (an example of a network). The database device 1 manages an information group including confidential information such as personal information. The user accesses the database apparatus 1 by operating the user terminal 4 in order to extract information from the database apparatus 1 or store the information for an originally appropriate purpose such as a task in charge. The management server 3 performs management so as to prevent unauthorized access from the user terminal 4 to the database apparatus 1 and to execute only proper access.

In this management system, it is necessary to first perform pre-processing by a user who operates the user terminal 4 and pre-processing by an administrator who operates the administrator terminal 3. For example, at the end of the month, the user applies for the use schedule of the database device 1 for the next month, and the administrator approves the application for the next month for each user within the current month.

First, pre-processing by the user will be described. FIG. 2 is a diagram illustrating the configuration of the management server related to the pre-processing by the user. For this process, the management server 2 performs a system user authentication unit 201, a database use schedule input unit 202, a database use plan storage unit 203,
The user key generation unit 204 and the user key transmission unit 205 are included.

FIG. 3 is a diagram showing a pre-processing flow by the user. In the user authentication process (S301), it is checked whether the user has the authority to use the management system, as in a normal system.

The user terminal 4 displays a system user authentication information input screen that prompts the user to input a system user ID and a system user password for receiving authentication as an appropriate user of the management system, and displays an operation unit. The system user ID and the system user password are accepted via Then, the received system user ID and system user password are transmitted to the management server 2. In the user authentication process (S301) by the system user authentication unit 201, the system user ID and the system user password are received from the user terminal 4, and the combination of the system user ID and the system user password registered in advance is received. It is determined whether it matches any of the above. If they match, the fact that the authentication was successful is returned to the user terminal 4 and the continuation of the process is permitted. In the case of a mismatch, the fact that the authentication has failed is returned to the user terminal 4 and the processing is interrupted. still,
The system user authentication information used here, that is, the system user ID and the system user password are not related to the database user registration information managed by the database described later.

When the user terminal 4 receives a notification that the authentication is successful, a database usage schedule setting unit (not shown) displays a database usage schedule setting screen that prompts the user to enter the database usage schedule, and the database usage schedule. Accept. Then, the received database utilization schedule is transmitted to the management server 2.

FIG. 4 is a diagram showing a database utilization schedule input screen. This screen is configured to designate a time zone during which the user accesses the database for business, that is, a scheduled start date and time and a scheduled end date and time (referred to as a database usage unit). These date and time zone lists are treated as database usage plans. It is also possible to use a work schedule as a database use schedule. In the case of a business form that always uses a database during work, it is reasonable to make the work schedule a direct database use schedule.

Database utilization schedule input processing by the database utilization schedule input unit 202 (S302)
Then, the above database use schedule is received from the user terminal 4 and stored in the database use schedule storage unit 203.

Next, user key generation processing (S303) by the user key generation unit 204 is performed. FIG. 5 is a diagram showing a user key generation processing flow. The following processing is repeated for each database usage unit included in the database usage schedule (S501). For example, a random number or character string consisting of a character or a number is generated by using a random number (S502). And the generated character
The number string is stored as a user key in the database use schedule storage unit 203 in association with the database use unit (S503). These processes are terminated when all the database usage units are completed (S504). In other words, for each database usage unit,
Generate an individual random user key.

Here, the database utilization schedule storage unit will be described. FIG. 6 is a diagram illustrating a configuration of the database utilization schedule storage unit. Each system user has a table. The header of this table stores the ID of the system user, and has a record for each database usage unit. In addition to the database usage unit 603, the record includes items of an approval 602, a user key 604, an encrypted database user name 605, and an encrypted database user password 606. At the time of user key generation, The fields of the items of approval 602, encrypted database user name 605, and encrypted database user password 606 have not been used yet. The approval 602 stores the result of the approval performed later by the administrator. The combination of the encrypted database user name 605 and the encrypted database user password 606 is an example of encrypted database user registration information to be described later. When the database user name and the database user password are encrypted together, the encrypted database user registration information encrypted as a whole is stored without distinguishing between 605 and 606.

Then, as shown in FIG. 3, user key transmission processing by the user key transmission unit 205 (S304)
I do. In this process, a user key corresponding to each database usage unit is returned to the user terminal 4. In this example, these are transferred in the form of a table. FIG. 7 is a diagram illustrating an example of a database usage unit and user key table. As shown in the figure, a user key corresponding to each database usage unit is stored. The user bears the duty of confidentiality for the user key received in this way, and manages it so that it is not known to others. The user key is required later when the user accesses the database apparatus 1 according to the schedule.

Next, pre-processing by the administrator will be described. FIG. 8 is a diagram illustrating a configuration of the management server related to the pre-processing by the administrator. The management server 2 further performs a system administrator authentication unit 801, an administrator key generation unit 802, a generation administrator key storage unit 803, and an administrator key transmission unit 8 for this process.
04, database use schedule approval request unit 805, database user registration information generation unit 80
6. Database user registration information encryption unit 807, user key deletion unit 808, and administrator key deletion unit 809.

FIG. 9 is a diagram showing a pre-processing flow by the administrator. System administrator authentication process (S9
In 01), it is checked whether the administrator has authority to use the management system.

The administrator terminal 3 displays a system administrator authentication information input screen for prompting input of a system administrator ID and a system administrator password for receiving authentication as an appropriate administrator of the present management system. Accept the administrator password. Then, the received system administrator ID and system administrator password are transmitted to the management server 2. In the system administrator authentication process (S901) by the system administrator authentication unit 801, the system administrator ID and the system administrator password are received from the administrator terminal 3, and the system administrator ID and the system administrator password registered in advance are received. Determine if they match. If they match, the manager terminal 3 is returned to the administrator terminal 3 and the processing is allowed to continue. If they do not match, the administrator terminal 3 is returned to the administrator terminal 3 and the processing is interrupted. The system administrator authentication information used here,
That is, the system administrator ID and the system administrator password are not related to database user registration information managed by a database described later.

When authentication of the system administrator is successful, an administrator key generation process (
S902) is performed.

FIG. 10 is a diagram showing an administrator key generation processing flow. The following processing is repeated for each management unit that is the validity period of the administrator key (for example, specified by date and time, or specified by day, week, or month) (S1001). A number / character string composed of randomly selected characters or numbers is generated by random numbers (S1002), and the generated character / number string is stored in association with the management unit as an administrator key (S1003). Then, the process ends for all management units (S1004). That is, an individual random user key is generated for each management unit.

In the administrator key transmission process (S903) by the administrator key transmission unit 804, the generated administrator key is returned to the administrator terminal 3 in association with the management unit. In this example, these are transferred in the form of a table. FIG. 11 is a diagram illustrating an example of a table of management units and administrator keys. As shown in the figure, an administrator key corresponding to each management unit specified by date and time is stored. The administrator bears a confidentiality obligation and manages the administrator key received in this manner so that it is not known to others. The administrator key is used to approve the access when the user actually accesses the database device 1 according to the schedule approved by the administrator.

Then, as shown in FIG. 9, the processing of S905 to S908 is repeated for each system user (
S904).

Database utilization schedule approval request processing by the database utilization schedule approval request unit 805 (S
905). In this processing, the administrator is allowed to register the approval of the database use schedule applied by each user. FIG. 12 is a diagram showing a database use schedule approval request processing flow. First, the system user name corresponding to the system user ID is acquired (S1201).
The system user name is stored in advance in the system user table (not shown).
Are stored in association with each other. Further, the database utilization schedule corresponding to the system user ID is acquired from the database utilization schedule storage unit 203 (S1202). Then, a database use schedule approval screen is generated that includes the system user ID, the system user name, and the database use schedule, and can input approval / disapproval for each database use unit (S1203).

FIG. 13 is a diagram showing a database use schedule approval screen. In this example, an approval (approval is possible) is instructed by checking an approval box. If not checked, a denial (approval denial) is instructed.

The database usage schedule approval request unit 805 transmits this database usage schedule approval screen to the administrator terminal 3 (S1204), receives approval approval for each database usage unit from the administrator terminal 3, and associates it with the database usage unit. Approval approval / disapproval (approval result) is stored in the database utilization schedule storage unit (S1205). Regardless of this example, it is possible to determine that the database usage schedule stored in the database usage schedule storage unit has been approved by deleting the database usage unit that is not approved and leaving only the database usage unit that can be approved. You may do it.

Next, database user registration information generation processing (S906) by the database user registration information generation unit 806 is performed as shown in FIG. In this process, database user registration information including a database user name and a database user password is generated. The database user registration information is information necessary for accessing the database device. FIG. 14 is a diagram showing a database user registration information generation processing flow. A random number or character string consisting of letters or numbers is generated by random numbers (S1401).
The numeric string is set as the database user name (S1402). In addition, a random number or character string composed of characters or numbers selected at random is generated (S1403).
The numeric string is used as the database user password (S1404).

Next, database user registration information encryption processing (S907) is performed by the database user registration information encryption unit 807 as shown in FIG. In this process, the database user registration information is encrypted with the user key and the administrator key.

FIG. 15 is a diagram illustrating a configuration of the database user registration information encryption unit. A user encryption unit 1501 that encrypts database user registration information with a user key to generate primary encrypted database user registration information, and encrypts the generated primary encryption database user registration information with an administrator key. Administrator encryption unit 1 for generating next encrypted database user registration information
502. As an encryption method performed by these elements, two input data (database user name and database user password) may be concatenated and encrypted together, or two input data (database user name and database user password). ) May be separately encrypted, and a combination of two obtained output data (encrypted database user name and encrypted database user password) may be treated as encrypted data (encrypted database user registration information).

These elements use encryption / decryption logic that can detect fraud when the encrypted data is to be decrypted with an unauthorized key (a key different from the key at the time of encryption). In other words, an encryption that enables determination of the match between the user key at the time of encryption and the user key at the time of decryption and the determination of the match between the administrator key at the time of encryption and the administrator key at the time of decryption To do. For example, at any stage of the encryption process, the encryption process is performed including the user key itself at the time of encryption or data that uniquely represents the user key at the time of encryption. Then, at the time of decryption, the user key or unique data at the time of encryption is extracted, and fraud is detected by comparing with the data that uniquely represents the user key at the time of decryption or the user key at the time of decryption Can do. Further, the logic may cause inconsistency in processing if decryption is performed using an unauthorized key.

FIG. 16 is a diagram showing a database user registration information encryption processing flow. First, the user encryption unit 1501 encrypts database user registration information composed of a database user name and a database user password using a user key to obtain primary encrypted database user registration information (S1601). Next, the administrator encryption unit 1502 further encrypts the primary encryption database user registration information with the administrator key to obtain secondary encryption database user registration information (S1602). Then, the secondary encrypted database user registration information is used as encrypted database user registration information that is output data of the processing (S1603).
).

User key deletion processing (S908) by the user key deletion unit 808 is performed. In this process, the user key of the user used in the above-described database user registration information encryption process is deleted from the database use schedule storage unit 203.

Then, when all the system users have been processed, the loop control is terminated (S90).
9) An administrator key deletion process (S910) by the administrator key deletion unit 809 is performed. In this process, the administrator key used in the above-described database user registration information encryption process (S907) is deleted from the generated administrator key storage unit 803.

  As described above, advance preparations by the user and the administrator are completed.

Next, processing when the user actually accesses the database will be described. In this management system, a create user is requested from the database device 1 for each database usage unit, and a separate database user name and database user password that are valid only within the database usage unit are registered in the database device 1. Hereinafter, processing at the start of database access will be described.

FIG. 17 is a diagram showing the configuration of the management server related to the processing at the start of database access. The management server 2 further performs an access start request reception unit 1701, a user key storage unit 1702, a database use schedule determination unit 1703, an access approval request unit 1704, an administrator key reception unit 1705, and an administrator key storage for this processing. Unit 1706, database user registration information decoding unit 1
707, a create user request unit 1708, and a primary decryption database user registration information transmission unit 1709.

FIG. 18 is a diagram showing a processing flow at the start of database access. First, as described above, the system user authentication process (S1801) by the system user authentication unit 201 is performed.

When the user terminal 4 receives a notification that the authentication is successful, an access start request instructing screen (not shown) prompts the user to input a user key and to instruct an access start request. And accepting a user key and an access start request instruction via the operation unit. At this time, the user specifies the database usage unit including the current time from the list acquired in the pre-processing, and inputs the user key corresponding to the database usage unit. Then, the user terminal 4 transmits an access start request including the received user key to the management server 2.

In the access start request receiving process (S1802) by the access start request receiving unit 1701, an access start request including the above-described user key is received from the user terminal 4. Then, the user key is stored in the user key storage unit 1702 in association with the system user ID acquired from the system user authentication unit 201.

Next, database utilization schedule determination processing (S
1803). In this process, it is determined whether or not the database is scheduled to be used.
For this purpose, a system user ID is acquired from the system user authentication unit 201, and a table corresponding to the system user ID is specified from the database use schedule storage unit 203. Then, the current date and current time are acquired from an internal calendar / timer unit (not shown), and it is determined whether the current time is included in any database usage unit of the database usage schedule of the table. If the database is scheduled to be used, that is, if the current time is included in any database usage unit, the processing is continued. On the other hand, if it does not fall under the database usage schedule, that is, if the current time is not included in any database usage unit,
The process is interrupted and terminated.

Next, an access approval request process (S1804) by the access approval request unit 1704 is performed. In this process, the administrator is requested to approve the user actually accessing the database. For this purpose, the access approval request unit 1704 acquires the system user name corresponding to the system user ID from the system user table (not shown), and the system user ID.
And the system user name, an access approval screen (not shown) on which access approval can be entered can be generated and transmitted to the administrator terminal 3. Then, the approval / disapproval for each database usage unit is received from the administrator terminal 3, and in the case of approval (approval is permitted), the process is continued, and in the case of denial (approval is not allowed), the process is interrupted and the process is terminated. .

Next, an administrator key receiving process (S1805) by the administrator key receiving unit 1705 is performed. In this process, a reply of the administrator key given in the pre-process is requested. Therefore, an administrator key input screen (not shown) that prompts the administrator terminal 3 to input the administrator key is generated and transmitted to the administrator terminal 3.

The administrator terminal 3 receives the administrator key input screen, displays it, and accepts the administrator key. At this time, the administrator specifies the management unit including the current time from the list acquired in the pre-processing,
Enter the administrator key corresponding to the management unit. Then, the administrator terminal 3 transmits the received administrator key to the management server 2.

The administrator key receiving unit 1705 receives the administrator key from the management server 2 and stores the received administrator key in the administrator key storage unit 1706.

Next, the database user registration information decoding unit 1707 performs database user registration information decoding processing (S1806). In this process, the encrypted database user registration information is decrypted with the administrator key and the user key.

FIG. 19 is a diagram illustrating a configuration of the database user registration information decoding unit. An administrator decrypting unit 1901 for decrypting encrypted database user registration information with an administrator key and generating primary decryption database user registration information; a decryption of the generated primary decryption database user registration information with a user key; and a secondary decryption database And a user decrypting unit 1902 for generating user registration information. In the case of the above encryption, when two input data (database user name and database user password) are concatenated and encrypted as a unit, these decryption units decrypt the encrypted data as a unit. . Also, the two input data (database user name and database user password) are encrypted separately, and the combination of the two obtained output data (encrypted database user name and encrypted database user password) is encrypted data (encrypted). If the data is handled as (encrypted database user registration information), the encrypted data is divided into two and each is decrypted.

As described above, when these decryption units try to decrypt the encrypted data with an unauthorized key,
It uses encryption / decryption logic that can detect fraud. In other words, by decryption logic that determines whether the user key at the time of encryption matches the user key at the time of decryption and whether the administrator key at the time of encryption matches the administrator key at the time of decryption Decrypt.

FIG. 20 is a diagram showing a database user registration information decoding process flow. The administrator key is read from the administrator key storage unit 1706, and the encrypted database user registration information corresponding to the database usage unit including the current time is read from the table of the system user ID of the database user schedule storage unit 203, and encrypted. The database user registration information is decrypted with the administrator key to obtain primary decryption database user registration information (S2001). At this time, if the administrator key used for decryption does not match the administrator key when the encrypted database is generated, fraud is detected in the decryption process, and the status is terminated as failure. On the other hand, if the administrator key used for decryption matches the administrator key when the encrypted database was generated,
Validity is detected by the decryption process, and the process is continued with a status of success. Next, the primary decryption database user registration information is further decrypted with the user key to obtain secondary decryption database user registration information (S2002). At this time, if the user key used for decryption does not match the user key when the encrypted database is generated, fraud is detected by the decryption process, and the status is terminated as failure. On the other hand, if the user key used for decryption matches the user key used when generating the encrypted database, the decryption process detects the legitimacy and sets the status as successful. Finally, the database user name and the database user password are specified using the secondary decryption database user registration information as the database user registration information that is output data of the process (S2003). When decrypted as a unit, the decryption result is divided into a database user name and a database user password in accordance with the concatenation method used for encryption. When decrypted separately, each decryption result is set as a database user name and a database user password.

As shown in FIG. 18, when the database user registration information decryption process is successful, a create user request process (S1807) by the create user request unit 1708 is performed. In this process, a create user command is transmitted to the database device 1 to request a new user registration (account generation). The create user command includes the database user name and the database user password obtained by the above-described processing. This makes it possible to log in to the database apparatus 1 using the database user name and the database user password thereafter.

Finally, primary decoding database user registration information transmission processing (S1808) by the primary decoding database user registration information transmission unit 1709 is performed. In this process, S2001 in FIG.
The primary decryption database user registration information obtained in (1) is transmitted to the user terminal 4.

When the above process is successful, the user terminal 4 can access the database device 1.

FIG. 21 is a diagram illustrating a configuration of a user terminal related to processing during data access. The user terminal 4 performs a primary decryption database user registration information receiving unit 2101, a user key input unit 2102, a user decryption unit 2103, a database login request unit 2104, a database access request unit 2105, and a database logout for this processing. It has an element of the request unit 2106.

FIG. 22 is a diagram showing a processing flow of the user terminal at the time of data access. First, primary decoding database user registration information reception processing (S2201) by the primary decoding database user registration information receiving unit 2101 is performed. In this process, the primary decryption database user registration information sent by the primary decryption database user registration information transmission process (S1808) shown in FIG. 18 is received.

Next, user key input processing (S2202) by the user key input unit 2102 is performed. In this process, the user is prompted to input a user key, and the user key is accepted. Also at this time, the user inputs the user key corresponding to the database usage unit including the current time. The user key input to the access start request instruction screen in the above-described process may be used without inputting again.

Next, user decryption processing (S2203) by the user decryption unit 2103 is performed. In this process, the primary decryption database user registration information is decrypted with the user key to obtain secondary decryption database user registration information. At this time, if the user key used for decryption does not match the user key when the encrypted database is generated, fraud is detected by the decryption process, and the status is terminated as failure. On the other hand, if the user key used for decryption matches the user key used when generating the encrypted database, the decryption process detects the legitimacy and sets the status as successful. Then, the database user name and the database user password are specified using the secondary decryption database user registration information as the database user registration information that is output data of the process. When decrypted as a unit, the decryption result is divided into a database user name and a database user password in accordance with the concatenation method used for encryption. When decrypted separately, each decryption result is set as a database user name and a database user password.

Then, database login processing (S2) by the database login request unit 2104
204). In this process, the database user name and the database user password are passed and the database apparatus 1 is logged in.

Subsequently, database access processing (S2 by the database access request unit 2105).
205). In this process, for example, data of the database device 1 can be acquired or data can be written.

When the access to the database device 1 is finished, the database logout request unit 21
The database logout process (S2206) is performed according to 06. Send logout command and exit.

When data access to the database within the database usage unit is completed, the user
An operation for deleting a user (account) registered in the database apparatus 1 is performed.

FIG. 23 is a diagram illustrating a configuration of a management server related to processing at the time of termination of data access from a user terminal. The management server 2 further performs an access end notification accepting unit 2301,
And an element of a drop user request unit 2302.

FIG. 24 is a diagram showing a processing flow at the end of data access from the user terminal. In the access end notification receiving process (S2401) by the access end notification receiving unit 2301, an access end notification (which may include a user key) is received from the user terminal 4. Next, the database user registration information decoding unit 1707 performs database user registration information decoding processing (S24).
02). In this processing, the encrypted database user registration information corresponding to the system user ID is read from the database use schedule storage unit 203, and the administrator key stored in the administrator key storage unit 1706 and the access end notification reception unit 2301 are used. The encrypted database user registration information is decrypted using the user key received together with the access end notification. Instead of receiving the user key at the access end notification receiving unit 2301, the user key stored in the user key storage unit 1702 in association with the system user ID may be read and used.

The processing of the database user registration information decoding unit 1707 is the same as described above. Regardless of this example, S2402 is omitted, and the above-described processing of the database user registration information decoding unit 1707 (
The decoding result obtained in S1806) of FIG. 18 may be used.

Then, the drop user request processing by the drop user request unit 2302 (S2403)
I do. With this processing, a drop user command including the database user name and database user password obtained by the decryption processing of the database user registration information decryption unit 1707 is transmitted to the database device 1. Thereby, the user registration (account) of the database apparatus 1 is deleted.

Embodiment 2. FIG.
In the above-described processing, the user himself / herself instructed the processing at the end of data access in consideration of the end of access to the database device 1 within the database usage unit, but the usage end scheduled date and time of the database usage unit has passed. At the time, the management server 2 can automatically delete the user registration (account).

FIG. 25 is a diagram showing the configuration of the management server related to the processing when the database utilization schedule is over. The management server 2 further performs a database use schedule end determination unit 2501 for this processing.
Have

FIG. 26 is a diagram showing a processing flow when the database utilization schedule is over. First, the database use schedule end determination unit 2501 performs database use schedule end determination processing (S26).
01). In this process, the database usage unit corresponding to the system user ID is acquired from the database usage schedule storage unit 203, and it is determined whether or not the end point has elapsed. If the time has elapsed, the database user registration information decoding unit 1707 performs database user registration information decoding processing (S2602). In this processing, the system user ID and the encrypted database user registration information corresponding to the database use unit are read from the database use plan storage unit 203 and the administrator key stored in the administrator key storage unit 1706 and the user Using the user key stored in the key storage unit 1702 in association with the system user ID, the encrypted database user registration information is decrypted. Database user registration information decoding unit 1707
This processing is the same as described above. Regardless of this example, S2602 may be omitted, and the decoding result obtained in the processing of the database user registration information decoding unit 1707 (S1806 in FIG. 18) may be used.

Subsequently, a drop user request process by the drop user request unit 2302 (S2603).
I do. With this processing, a drop user command including the database user name and database user password obtained by the decryption processing of the database user registration information decryption unit 1707 is transmitted to the database device 1. Thereby, the user registration (account) of the database apparatus 1 is deleted.

The database device 1, the management server 2, the administrator terminal 3, and the user terminal 4 are computers, and each element can execute processing by a program. Further, the program can be stored in a storage medium so that the computer can read the program from the storage medium.

FIG. 27 is a diagram illustrating a hardware configuration example of the database device 1, the management server 2, the administrator terminal 3, and the user terminal 4. Arithmetic device 2701 and data storage device 2702 are connected to the bus.
A memory 2703 and a communication interface 2704 are connected. Data storage device 2
Reference numeral 702 denotes a ROM (Read Only Memory) or a hard disk, for example. Memory 2703
Is a normal RAM (Random Access Memory).

The program is normally stored in the data storage device 2702, and is loaded into the memory 2703 and sequentially read into the arithmetic device 2701 for processing. The communication interface 2704 is used for communication via a local area network.

According to the present invention, the database registration information is not known to the outside, and the user and the administrator
Since the database registration information cannot be known, the database apparatus cannot be directly accessed. Also, if the administrator key and user key are not available, the user is not registered in the database device, so only those who know the user key (others who have stolen the use key or a malicious person) can access the database device. Can not do it. That is, if unauthorized access to the database device is detected, a complicity relationship between the user and the administrator is estimated.

In addition, when the key is appropriate, it is possible to obtain the database registration information by transmitting the primary decryption database registration information to the user terminal and decrypting it using the user key on the user terminal side. Only the user terminal can log in to the database device.

If the database usage schedule is exceeded, the user registration is forcibly deleted, so that unauthorized access outside the scheduled time can be prevented. In addition, there is no possibility that the user registration information of these users will be left after the user or administrator retires.

Since access start requests other than those scheduled to use the database approved by the administrator are automatically rejected, unauthorized access outside the scheduled time can be prevented.

Since the database usage schedule is divided into a plurality of database usage units, and different database user registration information and user keys are used for each unit, a new guard is provided for each database usage unit. In other words, safety is always ensured by dynamically updating information that serves as a key for protecting the secret.

In order for database user registration information to be generated and used, the following conditions must be satisfied.
(1) The usage schedule of the user is registered (2) The usage schedule is approved by the administrator (3) The usage is within the usage schedule of the user (4) The user's usage start request is made within the usage schedule (5) The user has not been notified of access termination (6) The management server has not been forcibly terminated

It is a figure which shows a network environment. It is a figure which shows the structure of the management server which concerns on the pre-processing by a user. It is a figure which shows the pre-processing flow by a user. It is a figure which shows a database utilization plan input screen. It is a figure which shows a user key production | generation process flow. It is a figure which shows the structure of a database utilization plan memory | storage part. It is a figure which shows the example of the table of a database utilization unit and a user key. It is a figure which shows the structure of the management server which concerns on the pre-processing by an administrator. It is a figure which shows the pre-processing flow by an administrator. It is a figure which shows an administrator key production | generation process flow. It is a figure which shows the example of the table of a management unit and an administrator key. It is a figure which shows a database utilization schedule approval request processing flow. It is a figure which shows a database utilization plan approval screen. It is a figure which shows a database user registration information generation process flow. It is a figure which shows the structure of a database user registration information encryption part. It is a figure which shows a database user registration information encryption processing flow. It is a figure which shows the structure of the management server which concerns on the process at the time of a database access start. It is a figure which shows the processing flow at the time of a database access start. It is a figure which shows the structure of a database user registration information decoding part. It is a figure which shows a database user registration information decoding process flow. It is a figure which shows the structure of the user terminal which concerns on the process at the time of data access. It is a figure which shows the processing flow of the user terminal at the time of data access. It is a figure which shows the structure of the management server which concerns on the process at the time of the end of the data access from a user terminal. It is a figure which shows the processing flow at the time of the end of the data access from a user terminal. It is a figure which shows the structure of the management server which concerns on the process at the time of database utilization plan over. It is a figure which shows the processing flow at the time of database utilization plan over. It is a figure which shows the hardware constitutions of each apparatus.

Explanation of symbols

1 database device, 2 management server, 3 administrator terminal, 4 user terminal, 201
System user authentication unit, 202 Database utilization schedule input unit, 203 Database utilization schedule storage unit, 204 User key generation unit, 205 User key transmission unit, 801 System administrator authentication unit, 802 Administrator key generation unit, 803 generation Administrator key storage unit, 804 Administrator key transmission unit, 805 Database use schedule approval request unit, 806 Database user registration information generation unit, 807 Database user registration information encryption unit, 808 User key deletion unit, 8
09 Administrator key deletion unit, 1501 User encryption unit, 1502 Administrator encryption unit, 170
DESCRIPTION OF SYMBOLS 1 Access start request reception part, 1702 User key memory | storage part, 1703 Database utilization plan determination part, 1704 Access approval request part, 1705 Administrator key receiving part, 1706 Administrator key memory | storage part, 1707 Database user registration information decoding part, 1708 Create user request unit, 1709 primary decryption database user registration information transmission unit, 1901 administrator decryption unit, 1902 user decryption unit, 2101 primary decryption database user registration information reception unit, 2102 user key input unit, 2103 user decryption unit, 2104 Database login request unit, 2105 Database access request unit, 2106 Database logout request unit, 2301 Access end notification reception unit, 2302 Drop user request unit, 25
01 Database use scheduled end determination unit.

Claims (3)

A database device that provides data to a user registered as a user, a user terminal operated by a user who uses the database device, and an administrator terminal operated by an administrator who manages the use of the database device by the user A management system having a management server connected to the database device and the user terminal connected to the database device,
The management server
(1) A user key generation unit that generates a user key unique to the user as pre-processing for the user to use the database device;
(2) A user key transmission unit that transmits the generated user key to the user terminal as pre-processing for the user to use the database device;
(3) An administrator key generation unit that generates an administrator key unique to the administrator as pre-processing for the user to use the database device;
(4) As a pre-process for the user to use the database device, an administrator key transmitting unit that transmits the generated administrator key to the administrator terminal;
(5) A database user registration information generating unit that generates database user registration information for newly registering a user in the database device as pre-processing for the user to use the database device;
(6) As pre-processing for the user to use the database device, the generated database user registration information is encrypted using the generated user key and the user key at the time of decryption and the user at the time of decryption. The primary encryption database user registration information is generated by encryption with an encryption logic that enables determination of key matching, and the generated primary encryption database user registration information is decrypted using the generated administrator key. At the time of encryption, the encryption key that makes it possible to determine whether the administrator key at the time of encryption and the administrator key at the time of decryption match, generate secondary encryption database user registration information, and the generated secondary encryption database A database user registration information encryption unit that sets the user registration information as encrypted database user registration information that is an encryption result;
(7) an encrypted database user registration information storage unit for storing encrypted database user registration information generated as an encryption result;
(8) An access start request receiving unit that receives a request for starting access from the user terminal to the database device together with the user key when the user uses the database device;
(9) an administrator key receiving unit that receives an administrator key from the administrator terminal when the user uses the database device;
(10) When the user uses the database device, the encrypted database user registration information stored in the encrypted database user registration information storage unit is encrypted using the received administrator key. The primary decryption database user registration information is generated by decrypting with the decryption logic that determines whether the administrator key matches the administrator key at the time of decryption, and the generated primary decryption database user registration information is received together with the request Using the user key, decryption is performed by the decryption logic that determines whether the user key at the time of encryption and the user key at the time of decryption match, to generate secondary decryption database user registration information. And if the user keys match,
A database user registration information decoding unit that uses the generated secondary decoding database user registration information as database user registration information that is a decoding result;
(11) When a user uses a database device, a create user request unit that transmits a create user command for new user registration including database user registration information obtained as a decryption result to the database device;
(12) a primary decryption database user registration information transmitting unit configured to transmit the primary decryption database user registration information to a user terminal when the user uses the database device;
The user terminal is
(13) A primary decryption database user registration information receiving unit that receives the primary decryption database user registration information from the management server when the user uses the database device;
(14) a user key input unit for inputting a user key when the user uses the database device;
(15) When the user uses the database device, the received primary decryption database user registration information uses the input user key, and the user key at the time of encryption matches the user key at the time of decryption The decryption logic that determines whether or not to generate secondary decryption database user registration information, and when the user keys match, the generated secondary decryption database user registration information is the decryption result database user registration information A user decryption unit, and
(16) a database login request unit that transmits a login command including database user registration information obtained as a decoding result to the database device when the user uses the database device;
(17) a database access request unit that transmits an access command for data acquisition or data writing to the database device after login;
(18) A management system comprising a database logout request unit that transmits a logout command to the database device when access is terminated. The management server (19) according to claim 1, wherein the management server further comprises the following elements: a database use schedule storage unit (20) for storing a database use schedule for a user to use a database device according to claim 1; When using the database device, the database use schedule end determination unit (21) for determining that the use end scheduled date and time of the user's database use schedule has passed. A drop user request unit that transmits a drop user command for requesting deletion of user registration related to the database utilization schedule to the apparatus. 2. The management system according to claim 1, wherein the management server further comprises the following elements: The user uses the database device from the user terminal as pre-processing for the user to use the database device. A database utilization schedule input unit for receiving a database utilization schedule to be performed (23) a database utilization schedule storage unit for storing the received database utilization schedule (24) stored in the database utilization schedule storage unit as a pre-process for the user to use the database device Request for approval for the database usage schedule being sent to the administrator terminal, receiving the approval result from the administrator terminal, and determining that the database usage schedule stored in the database usage schedule storage unit is approved Database utilization schedule approval request part (25) to be used by the user database device In utilizing the database usage determination unit determines whether the database drive schedule approved.

Images