Free Preparation Discussions
MENU
Snowflake ADA-C01 Exam - Topic 4 Question 49 Discussion
Topic #: 4
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?
According to the Working with Secure Views documentation, secure views are designed to limit access to sensitive data that should not be exposed to all users of the underlying table(s). When sharing secure views with another account, the view definition must include a function that returns the identity of the user who is querying the view, such as CURRENT_USER, CURRENT_ROLE, or CURRENT_ACCOUNT. These functions can be used to filter the rows in the base table based on the user's identity. For example, a secure view can use the CURRENT_USER function to compare the user name with a column in the base table that contains the authorized user names. Only the rows that match the user name will be returned by the view. The CURRENT_CLIENT function is not suitable for this purpose, because it returns the IP address of the client that is connected to Snowflake, which is not related to the user's identity.
Arlette
17 days agoGertude
23 days agoAvery
28 days agoBobbie
1 month agoCristy
1 month agoGerman
1 month agoElenora
2 months agoXochitl
2 months agoLea
2 months agoKristeen
2 months agoJuan
2 months agoLeonora
2 months ago