Question: Suppose that a database includes the following relations. employee ( id , name, address, age, dept _ no * ) department ( dept _ no
Suppose that a database includes the following relations.
employeeid name, address, age, deptno
departmentdeptno deptname, location, building
projectprojectNumber subject, level, deptno
i The Users of the database are:
Isavella who is authorised to do anything with the relations;
Laura who can see and change all employee details, but cannot add or delete new employees and cannot access the other relations;
Naser who has the same authorisation as Laura.
Write SQL statements that give these Users the access described above.
marks
ii Suppose that there is another User, Jane, who can only see projects for which leveladvanced; she is not authorised to do anything else. Write SQL statements that implement this.
marks
iii Now suppose that Naser has now moved to another company and, therefore, should no longer have access to the database. Write a SQL statement to implement this.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
