One of my users (a member of RMS - Administration group) inquired this week about why they couldn't delete data views they didn't create. They belong to the same security groups as my own account, and so I was able to verify that there are certain Data Views for which the "Delete" link is missing.

Both our users belong to "RSR - Administration", "RSR - Staff Workers" and a custom "Restrict from Financial" group I set up which is not referenced in the Data Views in any way.

I looked at the security information on our various dataviews, and it appears that upon creation, the creator is added as an explicit "Allow" entry to "Edit" and "Administrate". Which I suppose makes some amount of sense except that (IIRC) out of the box you have to be an administrator to create one in the first place and so you should have full control regardless.

At any rate, the inherited "Global Default" permissions listed below the explicit permissions list "RSR - Administration" as "Allow" on "Edit" and "Administrate", followed by "Deny" for "All Users" for "Edit" and "Administrate". Which, unless I'm mistaken, should mean that all users within "RSR - Administration" are allowed to edit and administrate all the data views.

So why can we not see the Delete button on data views which we did not create? Even more oddly, there are other Data Views which appear to have the same explicit permissions set (presumably the same user created them) for which we CAN see the delete link. If it matters, the account with the explicit "allow" permissions no longer works at the church, and so the user profile has been removed from all security groups, and the login associated with their account deleted. Yet, some of the Data Views they created during their employment can be deleted, and others apparently cannot.

I feel like I've run into this before- perhaps even asked this question before- but I haven't been able to find the thread where I may have done so and can't find any notes of my own indicating what, if any, solution I arrived at. I apologize if this is a duplicate.