Suppose A Schema A Grants The Create Any Trigger With Admin Option Pr

1.	Suppose A Schema A Grants The Create Any Trigger With Admin Option Privilege To A Schema B And The Schema B Grants The Create Any Trigger Privilege To A Schema C. If The Schema A Revokes This Privilege On The Schema B, Then Does The Privilege On Schema C Be Revoked As Well?
Answer» No, the PRIVILEGE on the SCHEMA C will not be revoked AUTOMATICALLY; only the privilege on the schema B is revoked. No, the privilege on the schema C will not be revoked automatically; only the privilege on the schema B is revoked.

Suppose A Schema A Grants The Create Any Trigger With Admin Option Privilege To A Schema B And The Schema B Grants The Create Any Trigger Privilege To A Schema C. If The Schema A Revokes This Privilege On The Schema B, Then Does The Privilege On Schema C Be Revoked As Well?

Answer»

No, the PRIVILEGE on the SCHEMA C will not be revoked AUTOMATICALLY; only the privilege on the schema B is revoked.

No, the privilege on the schema C will not be revoked automatically; only the privilege on the schema B is revoked.