SnowPro Core Certification — Question 883

Which function should be used to authorize users to access rows in a base table when using secure views with Secure Data Sharing?

Answer options

• A. CURRENT_ACCOUNT()
• B. CURRENT_ROLE()
• C. CURRENT_SESSION()
• D. CURRENT_USER()

Correct answer: A

Explanation

The correct answer is A, CURRENT_ACCOUNT(), because it identifies the account currently in use, which is essential for authorizing access in secure views. The other options do not serve this specific purpose as they refer to roles, sessions, or users, which do not directly control access to rows in the context of Secure Data Sharing.