When a database is cloned, which privileges of the original database are replicated in the cloned database?

• A. ALL privileges associated with the original database and the child objects
• B. Database level privileges only
• C. Child object-level privileges only
• D. Future privileges only

Answer: (C)

When a database is cloned, the access on the actual objects inside the database is preserved in the clone. Each child object (schemas, tables, views, etc.) carries its own privilege grants, and those object-level grants are replicated so that the same principals have the same access on the corresponding objects in the clone. However, privileges granted at the database level aren’t automatically copied to the clone because the clone is a separate securable with its own grant state. Likewise, future privileges (grants that apply to objects created in the future) don’t automatically transfer to the clone. In short, only the existing object-level grants on the child objects are replicated.