Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for auditing and blocking OracleTNS protocol SQL execution using secure gateway

A security gateway and protocol technology, applied in transmission systems, electrical components, etc., can solve problems such as failure to establish unified processing logic, failure to clarify package inclusion and logical relationships, and failure to correctly parse

Pending Publication Date: 2021-01-05
北京景安云信科技有限公司
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1. Due to Oracle's continuous upgrade, the existing solution cannot be parsed correctly under 0racle12c 64-bit
[0004] 2. The existing solution does not clarify the inclusion and logical relationship between packages, and cannot establish a unified processing logic

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
  • Method and system for auditing and blocking OracleTNS protocol SQL execution using secure gateway
  • Method and system for auditing and blocking OracleTNS protocol SQL execution using secure gateway
  • Method and system for auditing and blocking OracleTNS protocol SQL execution using secure gateway

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The technical solution of the present invention will be further described below in conjunction with specific embodiments and accompanying drawings.

[0045] Such as figure 1 Shown, a kind of method that uses security gateway of the present invention to carry out auditing and blocking to Oracle TNS protocol SQL, described method specifically comprises the following steps:

[0046] S1) Obtain a data packet, and analyze and process the data packet, and obtain a data array after processing;

[0047] S2) performing a digit judgment on the data array processed in S1);

[0048] S3) judge the type of the data array obtained in S1), and execute S4), S5) or S6) according to the judgment result;

[0049] S4) performing command analysis according to the judgment result of S3);

[0050] S5) carry out 1169 packet analysis according to the judgment result of S3), execute S4) after the analysis is completed;

[0051] S6) Perform 116b packet analysis according to the judgment result...

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 relates to the field of computer database access control, in particular to a method for auditing and blocking Oracle TNS protocol SQL execution through a secure gateway. The method specifically comprises the following steps: acquiring a data packet, analyzing the data packet, and obtaining a data array after analysis; determining the bit number of the processed data array; determining the type of the obtained data array, and performing command analysis according to a determination result; or performing 1169 packet analysis or 116b packet analysis according to the determination result, and performing command analysis after the analysis is completed. According to the method, a 32-bit client and a 64-bit client can be distinguished, the method is compatible with various versionsof oracle 11g and 12c, different client types can be balanced, and the method is suitable for various clients such as sqlplus, Navicat and jdbc.

Description

technical field [0001] The invention relates to the field of computer database access control, in particular to a system for auditing and blocking Oracle TNS protocol SQL execution with a security gateway. Background technique [0002] The existing technical solution does not distinguish the number of digits of the client and the number of the server for TNS analysis, which will cause the situation that the sql cannot be correctly obtained under the circumstances of different clients (64-bit clients and Oracle JDBC clients) and servers. The analysis of the SQL execution is incomplete, only the command packets of type 0x035e and 0x1169 can be analyzed, and there is no analysis plan for the 0x116b packet. [0003] 1. Due to Oracle's continuous upgrade, the existing solution cannot be parsed correctly under 0racle12c 64-bit [0004] 2. The existing solution does not clarify the inclusion and logical relationship between packages, and cannot establish a unified processing logic...

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
Patent Type & Authority Applications(China)
IPC IPC(8): H04L29/06
CPCH04L69/22H04L63/0245
Inventor 朱燚庄恩贵张兵兵
Owner 北京景安云信科技有限公司