Show the grant diagrams after steps (4) through (6) of the sequence of actions listed in Fig. 10.6.

Assume A is owner of the relation to which privilege p refers.

Figure 10.6: Sequence of actions for Exercise 10.1.2.

Transcribed Image Text:

Step By By 1 A 2 A 3 B 4 D 5 B 6 A Action GRANT p TO B WITH GRANT OPTION GRANT p TO C GRANT p TO D WITH GRANT OPTION GRANT p TO B, C, E WITH GRANT OPTION REVOKE p FROM D CASCADE REVOKE p FROM C CASCADE Step By By 1 A 2 A 3 B 4 D 5 B 6 A Action GRANT p TO B WITH GRANT OPTION GRANT p TO C GRANT p TO D WITH GRANT OPTION GRANT p TO B, C, E WITH GRANT OPTION REVOKE p FROM D CASCADE REVOKE p FROM C CASCADE

Answer rating: 100% (QA)

Grant Diagrams To overcome the overlapping privileges and complex web of grants it is easy to repres... View the full answer