You can change things via SQL query but it's not something I would post on a public forum. I know development would prefer we not interact directly with the DB but in this case it might be a have to. However, development probably can help you directly, so you need to open a TAC case to get to them for help.
In answer to your question directly, I have done (via SQL) what you are needing but again it's not something to post publicly.
Please open a TAC case.
--Shaun Roberts Principal Engineer, CX email@example.com
The only supported method would be to re-create the TAP. That is, remove all objects from the current TAP, delete the original TAP and re-create it as a community TAP. If there are other TAPs that depend on the old TAP, you will need to "Refresh References" in all of those, before deleting the old TAP, but AFTER you have created the new TAP (AFTER because your other TAPs will try to grab objects they need if they do not currently belong to a TAP)
Join us live on Thursday, April 8 at 10 am PT (and on demand after) as we join Cisco and HashiCorp executives to discuss the importance of IaC automation, Intersight Service for Terraform, and how to better manage hybrid cloud infrastructure at scale...
Join us live on Thursday, April 8 at 10 am PT (and on demand after) where Cisco and HashiCorp executives will discuss the importance of IaC automation, Cisco Intersight Service for Hashicorp Terraform, and how to better manage hybrid cloud infrastructure...
How to START with Infrastructure as a code for Cisco Cloud Solutions
ACI Ansible Modules Documentation Guide
Cisco Collections on Ansible Galaxy
Cisco DevNet Learning Labs
DevNet Introduction to ACI and Ansible
DevNet Introduction to ACI a...
Here's how to get notified about Cisco software releases, like the Application Policy Infrastructure Controller (APIC) (APIC Software)
Go to software.cisco.com - where you download all Cisco software
Select Software Download