'Can you create a View of a database Share, as a consumer?

I am trying to create a View of a database share (I am the consumer of the share).

e.g.

create view testview as (select * from myshare);

results in this error:

SQL execution error: Creating view on shared database 'myshare' is not allowed.

I didn't see any conclusive documentation around this. If this is not allowed, are there any workarounds to accomplish a similar outcome?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source