dataall icon indicating copy to clipboard operation
dataall copied to clipboard

Database sharing

Open dlpzx opened this issue 3 years ago • 0 comments

Is your feature request related to a problem? Please describe. There are use-cases which require sharing of all tables of a database. With the current implementation we need to perform a share request adding each of the tables to the request.

Describe the solution you'd like I would like a more simplified straight-forward way of sharing all tables of a database.

Describe alternatives you've considered SHARING ------------ From the UI standpoint it could look like a toggle in the UI to "share all tables from database", once we submit in the background:

  1. share_object_items that are tables are unshared and deleted from RDSnshare_object_items table
  2. a share_object_item of type database is added in this table instead
  3. As stated above, table-by-table sharing is cleaned and we instead start the same process of "grant, RAM, resource link" with the database instead.

Back to the UI: Once the share is complete, it appears in the share_object_items table (the same one of folders and tables), but tables cannot be added until the database item has not been unshared.

REVOKING ---------- In a very similar way as tables, the database sharing revoke methods need to be implemented. The application logic for the database does not change from the one applied to folders or tables.

Additional context Add any other context or screenshots about the feature request here.

P.S. Please Don't attach files. Add code snippets directly in the message body instead.

dlpzx avatar Jul 13 '22 12:07 dlpzx