Ask Your Question
4

When a select query is being executed, is it possible for snowflake to restrict access to tables?

asked 2021-12-17 11:00:00 +0000

devzero gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2022-11-09 14:00:00 +0000

djk gravatar image

Yes, Snowflake provides access control to tables using a combination of roles and privileges. This allows the administrator to restrict access to certain tables based on the role of the user executing the select query. For example, a user with only read access to a table may not be able to execute select queries that include modifying data in that table. Additionally, Snowflake allows the administrator to set access policies that restrict access to tables based on specific conditions or criteria such as time of day, IP address or location.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-12-17 11:00:00 +0000

Seen: 1 times

Last updated: Nov 09 '22