Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A software development firm had been asked to develop access control mechanism for a Database Management System (DBMS). In this assignment you are asked to

A software development firm had been asked to develop access control mechanism for a Database Management
System (DBMS). In this assignment you are asked to perform the task of the security designer for that firm, i.e.,
designing and implementing the access control mechanism for the DBMS
The DBMS Access Control Mechanism (DACM) will receive SQL commands and either accept and perform the command or deny the command. SQL commands can be divided into four categories. The following are the four
categories and the minimal commands that you need for each category:
DDL (Data Definition Language): 1) Create; and 2) Drop.
DML (Data Manipulation Language): 1) Select; 2) Insert; and 3) Delete.
TCL (Transaction Control Language): 1) Commit; and 2) Rollback.
DCL (Data Control Language): 1) Grant; and 2) Revoke.
The database system has three types of users:
1. Security Officers: Manges users and passwords. In addition, they perform backup and recovery operations.
2. Regular Users: Users who are allowed to perform only DML operations.
3. Administrators: Perform the tasks of all the above.
Requirements
1. Implement a generic Access Control Matrix class that implements all the Access Control System Commands
in Table 4.3 of the book (slides).
2. Create the required objects and/or structures to implement the system described above.
3. Show the required initialization for the object of the Access Control Matric class.
4. Determine the type of this access control mechanism (DAC, MAC, RBAC, etc).
5. Demonstrate the abilities of the system to:
a. Add/remove users.
b. Authenticate users.
c. Create and drop databases and tables (Table structures and contents are not important).
d. Accept/Deny the SQL command received by the users.
6. It is essential to utilize the class implemented in requirement #1.
Note 1: You are not required to implement the whole DBMS system, only the sufficient part to perform the demonstration.
Note 2: This is a design assignment, so different correct implementations are possible.
Note 3: You can use any language that supports OOP.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 6th Asian Conference Aciids 2014 Bangkok Thailand April 7 9 2014 Proceedings Part I 9 2014 Proceedings Part 1 Lnai 8397

Authors: Ngoc-Thanh Nguyen ,Boonwat Attachoo ,Bogdan Trawinski ,Kulwadee Somboonviwat

2014th Edition

3319054759, 978-3319054759

More Books

Students also viewed these Databases questions

Question

Proficiency with Microsoft Word, Excel, PowerPoint

Answered: 1 week ago