Database Security and Implementation: Assignment with Oracle 11g – Assignment 6

Summary

Database security and implementation are covered. Students learn how to protect data and defend against SQL injection attacks. They also learn how to design and implement a database in Oracle 11g.

Database Security Mechanisms

Security mechanisms for databases are explained. These protect data confidentiality, integrity and availability. Some unique security requirements for database users and administrators are discussed.

SQL Injection Attacks

SQL injection attacks are described. These attacks exploit improper coding of web applications. Methods to prevent these attacks are outlined.

Physical Database Design

The physical design of a database is outlined. SQL commands to create database tables are listed. Students are asked to implement these tables in Oracle 11g.

Assignment Instructions

Students are asked to write a paper on database security and implementation. They must explain security mechanisms, defeat SQL injection attacks, outline physical database design, and list SQL commands. They must also implement tables in Oracle 11g and provide screen shots.

Key terms

SQL Injection

An attack that exploits improper coding of web applications to inject SQL commands.

Polyinstantiation

A technique that allows different records to exist in the same table at various security levels.

Rule of least privilege

A security principle that limits permissions of accounts that execute SQL queries.

Stored procedures

Techniques used to prevent users from directly interacting with SQL code.

2G and 3G technologies

Mobile phone technologies that use digital signaling and speech channels.

GSM

A mobile phone system that uses digital signaling and speech channels.

Questions this document helps with

• How can databases be secured?
• What are SQL injection attacks?
• How can SQL injection attacks be prevented?

Summary written with AI from the document's text.