In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
In data sharing, especially when dealing with secure views, it is essential to grant specific privileges that allow the referencing of objects within the databases. The correct privilege that must be granted on each database referenced by a secure view to be shared is `REFERENCE_USAGE`. This privilege ensures that the secure view can access the necessary data within the referenced databases while maintaining the security and integrity of the data.
it's correct
https://docs.snowflake.com/en/release-notes/bcr-bundles/2023_02/bcr-944
https://docs.snowflake.com/en/user-guide/data-sharing-multiple-db c