When revoking an object privilege that was issued with the WITH GRANT OPTION,the action will have a cascading effect because if that user granted the privilege to other users,the privilege will be revoked from them also.

Question

When revoking an object privilege that was issued with the WITH GRANT OPTION,the action will have a cascading effect because if that user granted the privilege to other users,the privilege will be revoked from them also.​

Quizplus · Accepted Answer

When a privilege is granted with the WITH GRANT OPTION, the recipient of the privilege can grant it to other users. Revoking the privilege from the original recipient will also revoke the privilege from all the users to whom it was granted. This is known as cascading effect.

When Revoking an Object Privilege That Was Issued with the WITH GRANT