COF-C02 · Question #422
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query…
The correct answer is C. If User2 has the ACCOUNTADMIN role they will be able to see the results. In Snowflake, query results are private to the user who executed the query. Other users - including those with SYSADMIN or SECURITYADMIN roles - cannot access another user's query result set. However, users with the ACCOUNTADMIN role have the highest level of privilege in a…
Question
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history. What will happen if User2 tries to access the query history?
Options
- AIf User2 has the sysadmin role they will be able to see the results.
- BIf User2 has the securityadmin role they will be able to see the results.
- CIf User2 has the ACCOUNTADMIN role they will be able to see the results.
- DUser2 will be unable to view the result set of the query executed by User.
How the community answered
(27 responses)- A7% (2)
- C89% (24)
- D4% (1)
Explanation
In Snowflake, query results are private to the user who executed the query. Other users - including those with SYSADMIN or SECURITYADMIN roles - cannot access another user's query result set. However, users with the ACCOUNTADMIN role have the highest level of privilege in a Snowflake account and can view query history details for all users through Snowsight's account-level query history, including result sets. SYSADMIN manages database objects but does not have cross-user query result visibility. SECURITYADMIN manages users and roles but similarly lacks access to other users' query result sets. Therefore, only ACCOUNTADMIN has the privilege to view User1's query results.
Topics
Community Discussion
No community discussion yet for this question.