What is the effect of specifying WITH MANAGED ACCESS on a schema?

• A. The schema owner centralizes privilege management
• B. Privileges are granted only by the object owner
• C. All objects are automatically shared
• D. Access cannot be revoked

Answer: (A)

With WITH MANAGED ACCESS, privilege management is centralized under the schema owner. This means the person or role that owns the schema is responsible for granting and revoking access to the schema and its contained objects, providing a single, auditable point of control. Object owners don’t independently grant access to others for the entire schema, which helps enforce consistent governance across all objects inside the schema. Access can be revoked just like it can be granted, so there’s no idea of access being permanent or unchangeable. This centralized approach is why this option best fits the behavior described. The other choices don’t fit because privileges aren’t granted only by object owners, not all objects are automatically shared, and access can indeed be revoked.