Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 3

Exercise 25.32
Consider the relational database schema of Figure 3.5. Suppose that all the relations were created by (and hence are owned by) user X, who wants to grant the following privileges to user accounts A, B, C, D, and E:
(a) Account A can retrieve or modify any relation except DEPENDENT and can grant any of these privileges to other users.
-Suppose that privilege (a) of exercise 25.32 is to be given with GRANT OPTION but only so that account A can grant it to at most five accounts, and each of these accounts can propagate the privilege to other accounts but without the GRANT OPTION privilege. What would the horizontal and vertical propagation limits be in this case?