cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Delete CDS in Default environment

Hello together,

 

I want to delete the CDS in my default environment. 

I think the same problem have @GarryPope, and @Dalebid1

 

I found this blog post: https://toddbaginski.com/blog/how-to-delete-a-previous-version-common-data-service-cds-database/ from @ToddBaginski (thank you for that!)

 

So with this, I find his mentioned Powershell cmdlets:

Remove-LegacyCDSDatabase

for 

Delete Common Data Service database

 

see https://docs.microsoft.com/en-us/power-platform/admin/powerapps-powershell#power-apps-cmdlets-for-ad...

 

Is there any reason why this shouldn’t work?

 

 

4E6288D0-8B10-499D-8418-496A628DB238.jpeg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Thanks for updating the question with your experience. If support is telling you that they can't delete it, that may be the way it is--they have recently changed some things about what environments that databases can be associated with.

 

You may be stuck with it--I would take the approach of restricting CDS security roles in default environment, renaming environment so that it is clear not to use it. I've even seen people go so far as to rename it "apps that will be deleted" and set the expectation that if anybody creates business grade apps in the default environment, the apps or flows will be deleted.

View solution in original post

9 REPLIES 9
Highlighted
Super User III
Super User III

the legacy cds database refers to the old cds 1.0, not the environments that you have now. Nobody still has CDS legacy databases.

If you created a cds databse in default environment and want to remove it, the only  answer is opening a ticket with microsoft support and asking them to delete it.

Highlighted

@jlindstromthanks for your feedback. I finally talked to microsoft and I was told that even the support cannot delete a CDS and I shall create a new idea for that.

Are you sure, that they can delete a CDS?

Highlighted

Thanks for updating the question with your experience. If support is telling you that they can't delete it, that may be the way it is--they have recently changed some things about what environments that databases can be associated with.

 

You may be stuck with it--I would take the approach of restricting CDS security roles in default environment, renaming environment so that it is clear not to use it. I've even seen people go so far as to rename it "apps that will be deleted" and set the expectation that if anybody creates business grade apps in the default environment, the apps or flows will be deleted.

View solution in original post

Highlighted

Thanks for your feedback.

 

Can I modify the permission in that CDS so, that it is not possible to create solutions?

Highlighted

Yes, that is controlled by the CDS security role given to the user.

 

in ppac, select default environment, click settings

User + Permissions

Users

Manage users in Dynamics 365

Select user

manage roles

uncheck security roles

 

This will prevent the users from creating solutions or doing anything with CDS in the default environment

 

Highlighted

@jlindstromso you mean I shall update all users? I'll have more than 8000 users there so that's not an option.

 

I checked the Security Roles that the users get in the default environment:

• Environment Maker

• Common Data Service User

 

With this, the user is able to create a solution.

 

My target is - like in an environment without CDS - that the users can create Canvas Apps and Flows, but nothing else.

Do you see a possibility to realize that?

Highlighted

There is a great option to do this--XrmToolBox User Role Manager. You could remove those roles from 8000 users in minutes. xrmtoolbox.com

You could also use this tool to bulk add a less permissive security role to the users.

without those permissions, users should be able to still create non CDs canvas apps and flows, but not solutions or CDs based apps.

role manager.png

Highlighted

Sounds great. I will check it out. 
thank you very much. 

I’ll coming back and write my feedback. 

Highlighted

Hi @max81 

 

This was suggested back in 2018 but was rejected by Microsoft for whatever reason (Too hard ??)

 

I dont know if you try again it will get approved.

 

Regards

 

Nigel

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Users online (8,753)