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 a) (6%) Present a Grant diagram describing all authorizations related to privileges on T. b) (3%) Which of the Grant statements, if any, would be disallowed? c) (3%) Which of the Revoke statements, if any, would be disallowed? d) (3%) After the statements complete execution (excluding any disallowed ones), what privileges does user Frank have on table 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 a) (6%) Present a Grant diagram describing all authorizations related to privileges on T. b) (3%) Which of the Grant statements, if any, would be disallowed? c) (3%) Which of the Revoke statements, if any, would be disallowed? d) (3%) After the statements complete execution (excluding any disallowed ones), what privileges does user Frank have on table T?