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 with owner Amy, and the following sequence of statements related to
privileges on Each statement is numbered and prefaced with the user issuing it
Amy: Grant Select on T to Bob With Grant Option
Bob: Grant Select on T to Carol With Grant Option
Carol: Grant SelectAC on T to David With Grant Option
Carol: Grant SelectAB on T to Eve With Grant Option
Amy: Grant Select on to Eve
Amy: Grant SelectC on T to Frank
David: Grant SelectAC on T to Frank With Grant Option
Eve: Grant Select on to Frank
David: Grant SelectA on T to Gary
Eve: Grant SelectA on T to Gary
Amy: Revoke Select on T From Eve Restrict
Carol: Revoke SelectAC on T From David Restrict
David: Revoke SelectA on T From Eve
Bob: Revoke Select on T From Carol Cascade
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
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
