matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Feature Request]: account

Open fengttt opened this issue 3 years ago • 1 comments

Is there an existing issue for the same feature request?

  • [X] I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

Right now when we connect to mo, we connect to a database. There need to be another level of namespace, let's call that account. When we deploy the database, we will create two account -- one "mo", which will hold all mo internal data/database. Another, "" is default account -- this is more or less for dev and test. Cloud deployment, either public or private should not need the "" default account, each customer must be assigned an account.

SQL connection string will need an account param. Once connected, client can only perform transactions on databases of his/her own account. For the same deployment we may later allow people to publish a database to another account. These published database is readonly, at a reasonably fresh snapshot.

Describe implementation you've considered

Works required at catalog, connection lib, and documentation. May have impact at transaction scope level.

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

fengttt avatar Jun 24 '22 16:06 fengttt

related to #3702

daviszhen avatar Aug 04 '22 06:08 daviszhen

I think it was soleved in 0.6. Why do you return it back to me ? @aressu1985

daviszhen avatar Nov 20 '22 13:11 daviszhen