As a data provider, if you own the objects in a share but do not own the share, how can you remove an object from the share?

• A. Revoking usage and/or select privileges from the share owner role
• B. Revoking usage and/or select privileges from the share owner role with CASCADE option
• C. User must request the share owner to remove the object from the share
• D. Revoking usage and/or select privileges from the share owner role with RESTRICT option

Answer: (B)

When removing an object from a share, focus on the privileges tied to that share. If you own the underlying object but not the share, you can revoke the privileges that the share has on that object. Using the CASCADE option ensures that the revoke propagates to all dependent privileges and effectively removes the share’s access to that object, which results in the object being removed from the share itself. Without CASCADE, the revocation might not fully cleanup the share’s access, and you’d risk leaving residual access or needing extra steps. Relying on the share owner to do the removal adds unnecessary delay, whereas revoking with CASCADE directly accomplishes the task.