The 21st century is the age of netizens. Internet has become a source of knowledge and platform for social media. Social networking sites have gained huge momentum among all age groups and the popularity has attracted users to devote hours on social networking and contributing to a huge repository of information at every minute. Privacy of this information becomes a critical function of the database. Since personal information of the user is subject to cyber crimes therefore, database level privacy is a fundamental requirement to protect the data. The rapid growth of web on the basis of applications and information system have farther expanded the risk exposure of databases and therefore, nowadays data protection is more important than previous. It is more significant to safeguard data not only from external intruders but also internal intruders. In this paper the various access control scheme and its models to attain the confidentiality, integrity and possibility of objectives of database security in the organization are discussed.