cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
max81
Kudo Kingpin
Kudo Kingpin

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

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
jlindstrom
Super User
Super User

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.

@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?

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

Thanks for your feedback.

 

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

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

 

@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?

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

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

I’ll coming back and write my feedback. 

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Users online (57,709)