Database: Consider the COMPANY schema. Suppose that all the relations were created by (and hence are owned by) user X. Using discretionary access control, show how user X can grant the following privileges to user accounts A, B, C, D, and E:
Account D can designate one of the attributes in a table he created as a foreign key to reference the Pnumber primary key in the PROJECT table.
EMPLOYEE
Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno
John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5
Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5
Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4
Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4
Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5
Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5
Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4
James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1
DEPARTMENT
Dname Research Administration Headquarters
DEPT_LOCATIONS
Dnumber Dlocation
1 Houston
4 Stafford
5 Bellaire
5 Sugarland
5
Dnumber Mgr_ssn Mgr_start_date
333445555 1988-05-22
987654321 1995-01-01
888665555 1981-06-19
5 4 1
WORKS_ON Essn Pno Hours
123456789 1 32.5
666884444 2 7.5
453453453 3 40.0
333445555 1 20.0
333445555 2 20.0
333445555 2 10.0
333445555 3 10.0
987987987 10 10.0
987987987 20 10.0
987987987 30 30.0
987987987 10 10.0
987987987 30 35.0
987987987 20 5.0
987987987 15.0 NULL
PROJECT
Pname Pnumber Plocation
ProductX 1 Bellaire
ProductY 2 Sugarland
ProductZ 3 Houston
Computerization 10 Stafford
Reorganization 20 Houston
Newbenefits 30 Stafford
wnua 5 5
123456789 666884444 453453453 453453453 333445555
4 1 4
333445555 333445555 333445555
DEPENDENT
Essn Dependent_name Sex Bdate Relationship
333445555 Alice F 1986-04-05 Daughter
333445555 Theodore M 1983-10-25 Son
987987987 Joy F 1958-05-03 Spouse
987987987 Abner M 1942-02-28 Spouse
987654321 Michael M 1988-01-04 Son
987654321 Alice F 1988-12-30 Daughter
888665555 Elizabeth F 1967-05-05 Spouse
999887777 999887777 987987987 987987987 987654321 987654321 888665555
333445555 987654321
123456789
123456789
123456789
F