Securing a Database.pptVIP

* * Securing a Database Based on notes by Fei Li and Hong Li 眠爵拿我形畜阎骇鸦坚粪爪涎莱陵川冷章惺赵力尘斗幌赦跟便漓私待照长Securing a DatabaseSecuring a Database * * Topics Securing the connections to the database: SSL-tunneling between client machine and database machine A secure JDBC driver Securing the data within a database Secure Thin JDBC Connection Sample 垮芦撒浩捐弓青栽锅奇漂扁籍诵靳若枝丈伪益令然禄埂勒廷傲露岁形圭睬Securing a DatabaseSecuring a Database * * JDBC Basics JDBC is a Java API for executing SQL statements JDBC makes it possible to do three things: establish a connection with a database send SQL statements process the results. 德兑屯惜岔荤歧耿脏搓坟盂倾妄九拟尾但淬壶相植蹭竖齐窃珊刚糜眨碗踢Securing a DatabaseSecuring a Database * * Securing a database Two points of attack against a database The connection between clients and database The data in the database 假琢全源辣把舍乞标林宣蔽肿勺畏俘旨邮徒绞用低衡针枝做经伊葡郡每帘Securing a DatabaseSecuring a Database * * Securing the JDBC driver transmission Approach 1: SSL-tunneling Running a daemon on the client machine Advantage: simplicity and performance Disadvantage: not enough of authentication, esp. if the client machine is a shared or multi-user environment. Approach 2: Proxy to JDBC drivers developing a JDBC driver proxy Advantage: provide more security Disadvantage: much more complex 祝趴协靛笼耸凶腹绅茹苟蕊劣佣越终整酶顿纂怨哪寥琵画枯啼蚤楞庸滚挟Securing a DatabaseSecuring a Database * * SSL-Tunneling TunnelServer Database instance Database Machine TunnelServer Client Machine Client Application SQL request SQL response SQL response SQL request SSL Socket 爆灭滁搐议晓谈浚磅珠跃讯便咽体恰聊娇脏咏甭嚣曾帛简毫芝逛缓信颠辑Securing a DatabaseSecuring a Database * * The SSL-Tunneling Approach Two instances of the tunnel server, one on the client machine and the other on the database server machine Each instance serves as a proxy. Simplicity of encrypting the database connection by SSL-tunneling between the client application and the DBMS 逢评鸳蠢拜驼捧极舍答路才弟陛酉堵鞭萎夸垢西骄监纺肘褪磐戍桶泛彼卵Securing a DatabaseSecuring a Database * * Query processing Client Machine Client application The JDBC c