Feature: tracing issue of share SQL support

[lichuang]

Summary

Feature: tracing issue of share SQL support

• Create and drop share #6974
• grant and revoke object. #6998
• alter share tenants #7043
• desc share #7104
• show shares #7144
• show grants on object and show grants of share_name #7180
• create database from share #7269
• add get and show tables from shared db SQL support. #7639

[BohuTANG]

Great!

cc @soyeric128 for documenting the 🚀 Data Sharing feature, thanks.

[soyeric128]

Hi @lichuang , could you pls show me the new commands introduced by this feature ?
Thanks.

[lichuang]

1. create and drop share.

create share test_share comment = 'comment';
DROP SHARE IF EXISTS test_share;

2. grant and revoke object.

grant USAGE on DATABASE show_shares TO SHARE test_share;
grant SELECT on TABLE show_shares.test_tb TO SHARE test_share;

3. alter share tenants

alter share test_share add tenants = 'a';

4. desc share

desc share test_share.

6. show shares

SHOW SHARES;

7. show grants on object and show grants of share_name

show grants of share test_share;
show grants on DATABASE show_shares;
show grants on TABLE show_shares.test_tb;

9. create database from share

create database db from share test_share.