Within a Snowflake account. permissions have been defined with custom roles and role hierarchies. To set up column-level masking using a role in the hierarchy of the current user, what command would be used?
A.
CURRENT_ROLE
B.
INVOKER_ROLE
C.
IS_ROLE_IN_SESSION
D.
IS_GRANTED_TO_INVOKER_ROLE
Answer:
d
User Votes:
A
50%
B
50%
C 3 votes
50%
D 1 votes
50%
Discussions
0/ 1000
satheesh
4 months, 2 weeks ago
IS_ROLE_IN_SESSION is a function in Snowflake that checks if a specified role is active in the current session. This is commonly used in conjunction with dynamic data masking to determine if a user has the necessary role to view unmasked data.
Want to join our community?
Please log in or signup in order to use this feature
IS_ROLE_IN_SESSION is a function in Snowflake that checks if a specified role is active in the current session. This is commonly used in conjunction with dynamic data masking to determine if a user has the necessary role to view unmasked data.