Grant with Grant on Views

Grant with Grant on Views

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. “; ; ; ;