Question: Consider a table T ( A , B , C ) with owner Amy, and the following sequence of statements related to privileges on T

Consider a table T(A,B,C) with owner Amy, and the following sequence of statements related to
privileges on T. Each statement is numbered and prefaced with the user issuing it.
1- Amy: Grant Select on T to Bob With Grant Option
2- Bob: Grant Select on T to Carol With Grant Option
3- Carol: Grant Select(A,C) on T to David With Grant Option
4- Carol: Grant Select(A,B) on T to Eve With Grant Option
5- Amy: Grant Select on T to Eve
6- Amy: Grant Select(C) on T to Frank
7- David: Grant Select(A,C) on T to Frank With Grant Option
8- Eve: Grant Select (A,C) on T to Frank
9- David: Grant Select(A) on T to Gary
10- Eve: Grant Select(A) on T to Gary
11- Amy: Revoke Select on T From Eve Restrict
12- Carol: Revoke Select(A,C) on T From David Restrict
13- David: Revoke Select(A) on T From Eve
14- Bob: Revoke Select on T From Carol Cascade
15- Amy: Revoke Select on T From Bob Restrict
Present a Grant diagram describing all authorizations related to privileges on T
draw the diagram and illustrate answer. please and thank you
Consider a table T ( A , B , C ) with owner Amy,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!