SnowPro Advanced: Architect — Question 139

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Choose two.)

Answer options

• A. Users with the SYSADMIN role can grant object privileges in a managed access schema.
• B. Users with the SECURITYADMIN role or higher can grant object privileges in a managed access schema.
• C. Users who are database owners can grant object privileges in a managed access schema.
• D. Users who are schema owners can grant object privileges in a managed access schema.
• E. Users who are object owners can grant object privileges in a managed access schema.

Correct answer: A, B

Explanation

The correct answers are A and B because only users with the SYSADMIN role and those with the SECURITYADMIN role or higher have the capability to grant object privileges in a managed access schema. The other options are incorrect since database owners, schema owners, and object owners do not inherently possess the authority to grant such privileges in this context.