This behavior change is in the 2022_08 bundle. In the 6.35 release, the bundle is disabled by default.
For the most up-to-date details about the version and date in which it will be enabled, as well as other release-related details, see the Behavior Change Log.
The behavior of the SHOW commands in a consumer account for which a share has been revoked has changed as follows:
|
Previously:
|
If a consumer account dha mounted two or more shares containing the same provider objects and later the provider revokes the account from only one of the shares, data was returned when SHOW commands were executed in the consumer account on the mounted database or schema in the remaining share(s).
For example, share1 and share2 containing the same provider objects were mounted in the xy12345 consumer account and then the provider removed the account from share2:
alter share share2 remove accounts = xy12345;
When any of the following commands were executed in the consumer account, valid data was returned:
SHOW <objects> IN DATABASE <revoked_mounted_db>;
SHOW <objects> IN SCHEMA <revoked_mounted_db>.<schema>;
|
|
Currently:
|
If the same scenario occurs, an error similar to the following is returned when executing the SHOW commands described above:
SQL compilation error: <details of the specific error>.
|
Ref: 851
