When cloning a database, schema or table, do privileges on the source object transfer to the cloned object?

• A. True
• B. Partially
• C. No privileges transfer
• D. All privileges transfer

Answer: (C)

Privileges are not transferred when you clone a database, schema, or table. A clone is a separate object with its own access control list, even though it shares the underlying data via zero-copy. This means you must grant the necessary privileges on the clone just as you would for a newly created object. The owner of the clone automatically has full control, but other roles must be explicitly granted the appropriate rights on the clone.