Which option should be used to allow a user to have only OWNERSHIP privilege on a table without being able to manage privilege grants?

• A. Create a managed schema
• B. Create a regular schema
• C. By default object owner will not be able to manage privileges on the object
• D. Use a different database

Answer: (A)

Ownership lets a user control a table, including the ability to grant privileges to others. To have a user own a table but not be able to manage privilege grants, place the table in a managed access schema. In a managed access schema, privilege management is governed separately and ownership does not implicitly confer the right to grant or revoke privileges, giving you the needed separation between owning an object and controlling its access.

If you used a regular (non-managed) schema, the object owner would retain the power to grant privileges to others, which contradicts the requirement. Using a different database doesn’t address how privileges are managed within objects.