COF-C02 Question #323: Real Exam Question with Answer & Explanation

The correct answer is C: The schema owner. In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema. This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects.

Account Access and Security

Question

When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

Options

AThe database owner
BThe object owner
CThe schema owner
DThe Snowflake user's role

Explanation

In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema. This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects.

Topics

#Managed Access Schema#Ownership Privilege#Access Control#Schema Owner

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions