Question: Please Help, I need help with the following programming assignment, please use PHP.... A software development firm had been asked to develop access control mechanism
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). 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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
