Question

In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?

(a) If DBA revokes authorization from u1 then u2 authorization is also revoked

(b) If u1 revokes authorization from u2 then u2 authorization is revoked

(c) If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked

(d) If u2 revokes authorization then u1 authorization is revoked

The question was asked in an online quiz.

The above asked question is from Authorizations topic in division SQL : Queries, Constraints and Triggers of Database Management

Answer 1

The correct answer is (c) If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked

Explanation: A user has an authorization if and only if there is a path from the root of the authorization graph down to the node representing the user.