In a managed schema, who centralizes privilege management?

• A. The schema owner
• B. The object owner
• C. The database owner
• D. The public role

Answer: (A)

In a managed schema, privilege management is centralized by the schema owner. This means the schema owner acts as the security administrator for that namespace, granting or revoking privileges on the schema and its contents to roles, rather than relying on individual object owners to manage access for every object. This setup simplifies governance and enforces consistent access control across all objects within the schema. The database owner handles database-wide privileges, not the schema’s centralized control, and the public role is just a general user-rights role, not a centralized privilege manager. Object owners can control privileges for their own objects, but in a managed schema the schema owner holds the overarching control.