Schema of Enhancing User Authentication and Encrypting Lob Data in ODBC Driver for Database

For commercial database management system is not suitable for storing sensitive data, the data is often encrypted in application before keeping into database. Using UDF (User Defined Function) can simplify the encrypting procedure, but it can't handle Lob (Long object) data. A schema of enhancing user authentication and encrypting Lob data in ODBC (Open Database Connection) driver for database is prosed. By adding necessary attributes of user authentication and cipher algorithm to encrypt Lob data in ODBC driver, the security of data stored in database is improved. Experiments show that the schema is transparent, efficient, easy to implement and reliable.

[1]  Michael Gertz,et al.  Handbook of Database Security - Applications and Trends , 2007, Handbook of Database Security.