Idea Details

Tenant Data Deletion

Last activity 07-26-2018 02:21 PM
pedrojramalho's profile image
12-05-2017 09:56 AM

When we need to delete tenant data pdm_tenant_delete command is available to help with the task:


D:\>pdm_tenant_delete -Q -t mytenantname

Are you sure you want to delete data for tenant 'mytenantname' ? (yes/no) yes

Are the constraints dropped ? (yes/no) yes

Table Name: NR_Comment Number of rows processed: 283

Number of rows succeeded: 283

Number of rows failed: 0 T

able Name: usp_ci_act_log

Number of rows processed: 24

Number of rows succeeded: 24

Number of rows failed: 0

Program completed.



Bold words are the input required by administrator so the command can execute. 


If the administrator wants to delete data for few tenants there's no problem in writing yes a couple of times. However, if the task is regarding several tenants the input required by administrator would transform this simple process in an inefficient method to clean up that data. Also, it would difficult to schedule this process to run outside working hours.


My suggestion is to change pdm_tenant_delete so it can consider several tenants in an input clause. Example: pdm_tenant_delete -Q -t ('mytenant1','mytenant2','mytenant3')


Thank you!


07-26-2018 02:21 PM

Thank you for submitting this idea. The product team has reviewed this idea and determined that it does not have enough support from the Community. Therefore, I have marked the idea as not planned. We greatly value your contributions to our community and are committed to continued engagement with you to improve our products.

12-22-2017 03:50 PM

Thank you for submitting this idea. The product team is reviewing this idea and is looking for additional input from other community members.


Community Members: If you agree that this is a good idea, please vote and add comments with details about your requirements.