COF-C02 Question 392

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  only schema owner can grant schema permissions

• Chose C1

  https://docs.snowflake.com/en/sql-reference/sql/grant-ownership#usage-notes A role that has the MANAGE GRANTS privilege can transfer ownership of an object to any role; in contrast, a role that does not have the MANAGE GRANTS privilege can only transfer ownership from itself to a child role within the role hierarchy. The transfer of ownership (GRANT OWNERSHIP) only affects existing objects at the time the command is issued. Any objects created after the command is issued are owned by the role in use when the object is created.

• 1

  Hi I cannot find where you identified above explanation. Frankly, I never saw this idea related to future objects from the schema. I thought that owners ship of the schema will transform it in a regular schema (with DAC approach).