Analysis of Database Security

This paper discusses how authorized users use various techniques to secure data schemes for getting privileged access and keeping database system security. However, there are different threats to databases such as SQL inject attack that would have caused loss of integrity, availability, and confidentiality. Therefore, firstly we introduce different control measures and then discuss mechanisms for granting and revoking privileges in the relational database system. In the paper, we specify security mechanisms including discretionary access control, mandatory access control, role-based access control, and XML access control. Furthermore, we offer specific preventive measures to a major threat, which is SQL injection in the database. Even for statistical databases, there are security problems, so it is important to pay attention to flow control and covert channels. To keep data encrypted, we summarize encryption and symmetric key and asymmetric key infrastructure schemes and discuss digital certificates as well. On the other hand, we use privacy-preserving techniques to limit perform large-scale data mining and analysis. To maintain database security, we research current challenges and discuss Oracle label-based security.