In this lecture I learn about Database Security. Database security is the system, processes, and procedures that protect a database from unintended activity. Unintended activity can be categorized as authenticated misuse, malicious attacks or inadvertent mistakes made by authorized individuals or processes. Database security is also a specialty within the broader discipline of computer security. Database security become important because information is critical resource in enterprise, securing become billion dollar industry, and people want to protect their confidential information.
Characteristic of good database security
• Data independence
• Shared access
• Minimal redundancy
• Data consistency
• Data integrity
Level of database security
• Physical security – protection of personnel, hardware, programs, networks, and data from physical circumstances
• Operating system security – use of an access control matrix, capability and accessor list
• DBMS security – protection mechanisms and query modification
• Data encryption – such as RSA scheme and data encryption standard
Advantages of using database
• Shared access
• Minimal redundancy
• Data consistency
• Data integrity
• Controlled access
LAB 6
This lab i learn about database security. Below are step how to install MySQL server.