Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
To allow secure views the ability to reference data in multiple databases, the REFERENCE_USAGE privilege must be granted on each database referenced by the secure view. This privilege enables access to the metadata of the referenced databases without exposing the actual data within them. This is important for maintaining a secure view of the data spanning multiple databases.
https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html
D is correct
correct
https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db
In addition to performing all the standard steps to share data, you must grant the REFERENCE_USAGE privilege on each database referenced by a secure view you wish to share. However, you do not need to grant REFERENCE_USAGE on the database where the secure view is created.