Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Oracle database access method applied to operation and maintenance auditing system

An access method and database technology, applied in the field of oracle database access, to achieve the effects of improving security, improving security performance, and preventing malicious attacks

Active Publication Date: 2017-09-01
CHENGDU DBAPP SECURITY
View PDF11 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The object of the present invention is to provide a kind of oracle database access method that is applied to operation and maintenance audit system, adopts the configuration file that downloads operation and maintenance audit system to generate to client configuration catalog, selects the mode of login from client, is used for solving existing In technology, accessing the oracle database requires logging in to the operation and maintenance audit system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Oracle database access method applied to operation and maintenance auditing system
  • Oracle database access method applied to operation and maintenance auditing system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] combined with figure 1 and figure 2 As shown, a method for accessing an oracle database applied to an operation and maintenance audit system includes the following steps:

[0045] 1) The operation and maintenance audit system administrator logs in to the operation and maintenance audit system, creates database assets, generates configuration files, and authorizes the operation and maintenance audit system users;

[0046] 2) The operation and maintenance audit system user logs in to the operation and maintenance audit system, downloads the configuration file to the oracle database client configuration directory;

[0047] 3) The operation and maintenance audit system user logs in to the oracle database client, and selects the database asset in the client drop-down list to log in;

[0048] 4) The operation and maintenance audit system interacts with the oracle database client, the authentication passes, and enters the audit state. If the authentication fails, the oracle...

Embodiment 2

[0052] On the basis of Example 1, in conjunction with the attached figure 1 and figure 2 As shown, the database assets include the user name of the oracle database server, the user password of the oracle database server, the instance name, the login attribute, the login role, and the ip and port.

[0053] When the operation and maintenance audit system administrator creates database assets, he writes the ip and port of the oracle database server into the configuration file, so when the operation and maintenance audit user downloads the configuration file to the configuration directory of the oracle database client, the oracle database client can obtain oracle database server information, and access the oracle database server through the database protocol TNS protocol.

Embodiment 3

[0055] On the basis of embodiment 2, in conjunction with the attached figure 1 and figure 2 As shown, in the step 1), the specific steps include:

[0056] 1.1) The administrator of the operation and maintenance audit system logs in to the operation and maintenance audit system;

[0057] 1.2) Read the database assets of the operation and maintenance audit system;

[0058] 1.3) Fill in the ip and port of the database server of the operation and maintenance audit system into the HOST field value and PORT field value of the configuration file;

[0059] 1.4) If the login attribute of the database asset is SID, then combine the user name of the operation and maintenance audit system, the user name of the oracle database server, instance name, login role, ip and port into the SID field of the configuration file; if the login attribute is SERVICENAME , the user name of the operation and maintenance audit system, the user name of the oracle database server, instance name, login rol...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses an oracle database access method applied to an operation and maintenance auditing system. The method comprises the following steps that 1) an administrator logs in the operation and maintenance auditing system to create database assets and generate a configuration file; 2) an operation and maintenance auditing system user logs in the operation and maintenance auditing system to download the configuration file to a configuration directory of an oracle database client; 3) the operation and maintenance auditing system user selects the database assets and logs in the oracle database client; 4) the operation and maintenance auditing system interacts with the oracle database client, and enters an auditing state after the authentication is successful; and 5) when the operation and maintenance auditing system user logs in the oracle database client again, the steps 3) and 4) are repeated. According to the method, the purpose of securely accessing an oracle database is achieved without changing a database access habit of the user; and the user do not need to log in the operation and maintenance auditing system after downloading the configuration file, and performs access directly through the client, so that the working efficiency can be improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an oracle database access method applied to an operation and maintenance audit system. Background technique [0002] With the continuous development of operation and maintenance audit technology, more and more attention has been paid to the operation and maintenance audit of database. As database information is a kind of sensitive data, database access security is particularly important. Therefore, it is necessary to add authorization and authentication of data operation and maintenance audit to the operation and maintenance audit system. The operation and maintenance audit system saves the user information of the operation and maintenance audit system, the oracle database information and the authorization information of the oracle database to the user. Therefore, each access to the oracle database requires three authentications: user authentication, which is used to restrict ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F21/62G06F21/31H04L29/06
CPCG06F21/31G06F21/6218G06F2221/2141H04L63/08
Inventor 刘脐锺范渊吴永越郑学新刘韬
Owner CHENGDU DBAPP SECURITY
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com