admin管理员组

文章数量:1125450

I need to mask certain fields in a Snowflake table in such a way that the AccountAdmin is not able to view the unmasked data at all times. However, the AccountAdmin should have the ability to unmask the data on an ad-hoc basis whenever necessary.

The goal is for the AccountAdmin to be able to unmask and view the data when needed, and once the task is complete, they should continue to see the masked data. Currently, when the data is unmasked, the masking is removed entirely, making the unmasked data visible to all users, which presents a significant security risk.

Is there a way or workaround to allow the AccountAdmin to unmask data for their own use and revert to the masked view once done, without exposing the unmasked data to all users during that time?

How shall i build such masking policy in snowflake.

本文标签: Temporary Unmasking in Snowflake TableStack Overflow