Question

PART I – SQL Data Control Language and Views:

The users of the Medical database include three nurses (nurse_1, nurse_2, and nurse_3), three physicians (doc_1, doc_2, and doc_3), and one manager (manager_1), all of whom have been created by the DBA. You are asked to use SQL to create necessary roles and grant the indicated privileges to roles/users.

Medical DB Schema Diagram

Answer 1

create role 'admin' , 'doctors' , 'nurses' ;

GRANT ALL ON medical_table .* TO 'admin';

GRANT select ON medical_table.* TO 'nurses';

GRANT Insert,update,delete ON medical_table.* TO 'doctors';