database administrator 6 –

(using SQL Program and command answer all the Question )

#Shams Hospital is one of the leading health care service provider in Oman. It is established in the year 1996 and has a current patient’s strength of over 500 patients. The patient belong to different parts of the country. It employs full-time and part-time personnel. It offers various medical services in the field of outpatient and Inpatient. The hospital has an online system operational round the clock.

1- Consider the scenario given in task-2a and create any four users (e.g. fatma1, fatma2, fatma3, and fatma4) in the Shams Hospital database and assign the privilege to connect to the database. Out of the four usersnamed as , one user (i.e. fatma1) is for doctor and two users (i.e. fatma2 and fatma3) are for the managers. The fourth user (i.e. User4) is for the admin staff. Create two roles with the following privileges:

A) Data_Entry: can only insert and view the records on the table created by fatma4.

HoD: can only edit and delete the records on the table created by fatma4. Assign the roles created above to the users as indicated below:

B)Assign the role Data_Entry to the doctor (i.e. fatma1)

C)Assign the role HoD to the managers (i.e. fatma2 and fatma3)

D)For the admin staff (i.e. Fatma4) assign the privilege to create a new table. You may create any new table relevant to the task2a scenario. Your solution must include the necessary SQL commands as screenshots and brief explanation for each of the steps. Note:

The names of the four users must named as fatmaIf the user names are inappropriate, marks shall be deducted accordingly.

# All the answer should be in screen shot .and describe all the command use .

5- 0 % similarity and I need the references and citation as well.

Writing Hub