4.24

Suppose user A, who has all authorization privileges on a relation r, grants select on relation r to public with grant option. Suppose user B then grants select on r to A. Does this cause a cycle in the authorization graph? Explain why.


I don’t think so. Since user A has all authorization privileges on a relation r, B granting select on r to A doesn’t bring any new privilege to user A.

I guess this depends on the internals of the Database Management System.