Preserving Privacy and Optimizing Performance by setting Multi-Level Access Restrictions using VPD Policies with Locks

Abstract

Several organizations use databases that are mostly secured against impostors. Organizations take many network security precautions such as firewalls, and build network-based systems that detect intrusion. Although network security systems are important in protecting databases in this regard, securing the database systems themselves, and the procedures/functions and data within them, has possibly become more critical as networks are increasingly opened to wider access through the Internet. In order to prevent unauthorized access of data, several programs and procedures have been put in place for users to provide authentication before accessing a data. In this paper, we primarily focused on discussing a multi-level access control mechanism that uses a Virtual private database. Database returns customized results to each user using Virtual Private Database. We tried to overcome some of drawbacks of VPD such as mechanisms to project out certain attributes i.e., column level security and difficulties in writing predicates involving cases of cross-reference, joins of tables. This Research Paper also talk about preventing data loss for advanced database management systems, focuses issues such as policies in database as well as the essential capabilities: Protect, Monitor, Discover and Manage of the policies as it protect the privacy of the data and shouldn’t disrupt the lawful activities of any organization.