CODEWITHSUNDEEP
snowflake-cloud-data-platform
Vinay
Vinay

Reputation: 31

adding view's to outbound share (the view which is created by union of 2 objects from two different database)

I am trying to add the views to an outbound share, but the view is created by referencing to two databases and one of the databases is created from the inbound share.

So when I try to execute the following commands:

ALTER VIEW " " SET SECURE;
GRANT REFERENCE ON DATABASE "X" TO SHARE SHARE_A;
GRANT REFERENCE ON DATABASE "Y" TO SHARE SHARE_A;
GRANT SELECT ON VIEW " " TO SHARE " ";

error: Granting individual privileges on the imported databases is not allowed. Use "GRANT IMPORTED PRIVILEGES" instead.

But I guess we cannot grant imported privileges to a share right, so what would be the correct steps to add the views?

Upvotes: 1

Views: 199

Answers (1)

Gokhan Atil
Gokhan Atil

Reputation: 10039

... the view is created by referencing to two databases and one of the databases is created from the inbound share.

Shared databases and all the objects in the database cannot be forwarded (i.e. re-shared with other accounts).

https://docs.snowflake.com/en/user-guide/data-share-consumers.html#general-limitations-for-shared-databases

Upvotes: 2

Related Questions