Grant with Grant on Views
We know that a user can Grant, "grant" permissions to another user on the views created by him/her.
Lets say user A, granted Grant privilleges to user B, and user B in turn granted access to C.
Now what would happen, if user A revokes permissions from user B,
1) Permissions would be revoked from user B only.
2) Permissions would be revoked from user C only.
3) Permissions would be revoked from user B and C both.
3) Permissions would be revoked from user B and C both.
-Krishna