Cascading effects can be observed when revoking a system privilege that is related to a DML operation. For example, if the SELECT ANY TABLE privilege is granted to a user, and that user has created procedures that use the table, all procedures that are contained in the user's schema must be recompiled before they can be used again.
Revoking object privileges also cascades when given WITH GRANT OPTION.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment