SnowPro Advanced: Architect — Question 116

An Architect created a database using the role DB_OWNER and a schema with managed access within this database using the role SCHEMA_OWNER. The team created a table inside this schema using the role OBJECT_OWNER.

Which role will be required to grant privileges on the table to other roles?

Answer options

• A. DB_OWNER
• B. OBJECT_OWNER
• C. SECURITYADMIN
• D. SYSADMIN

Correct answer: A

Explanation

The DB_OWNER role has the authority to grant privileges on database objects like tables. Although OBJECT_OWNER created the table, they do not have the rights to grant permissions to other roles, making DB_OWNER the correct choice. The other roles listed do not possess the necessary permissions for this task.