How do managed access schemas help with data governance?
How do managed access schemas help with data governance?
Managed access schemas provide centralized privilege management by ensuring that only the schema owner or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema. This centralized control supports data governance by preventing individual object owners from making independent grant decisions, thereby maintaining consistent and secure access control policies across the schema.
B is correct answer With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management.
https://docs.snowflake.com/en/user-guide/security-access-control-configure#creating-managed-access-schemas
Ans is B
correct