topic Re: How can I delete someone elses data in Geodatabase Questions

How can I delete someone elses data

TobyTe_Rupe1 — Sun, 08 Oct 2017 22:10:05 GMT

Hello,

As part of data maintenance. I have data owned by a user (i.e dpi\userA). UserA has since left the company and I would now like to delete the data owned by this UserA. I have tried using arcMap and connecting to the Database as both SA and SDE users but still do not have the required privileges to do so from within ArcMap.

Any help thanks.

Re: How can I delete someone elses data

DanPatterson_Retired — Sun, 08 Oct 2017 22:47:07 GMT

doesn't someone have full rights?

Re: How can I delete someone elses data

TobyTe_Rupe1 — Sun, 08 Oct 2017 22:51:05 GMT

The scenario here is I would like SA, DBO or SDE to take care of the rights here.

Problem also in ArcMap I can not see using SA, DBO or SDE who has privileges on the data without logging in as this user.

Re: How can I delete someone elses data

VinceAngelo — Mon, 09 Oct 2017 03:16:17 GMT

This is probably one of only two valid reasons to use an account with Administrator access through a Database Connection folder (the other being for geodatabase upgrade). It's also a reminder to make sure that core tables are owned by a "headless" data ownership user, so that it is safe to archive (in FGDB) and delete the tables owned by departing users.

- V

Re: How can I delete someone elses data

DanPatterson_Retired — Mon, 09 Oct 2017 03:16:21 GMT

So your previous question doesn't apply then ?

https://community.esri.com/thread/203098-changing-the-ownership-of-a-feature-class-and-schema

Re: How can I delete someone elses data

Asrujit_SenGupta — Mon, 09 Oct 2017 05:43:26 GMT

There are some tasks in an Enterprise geodatabase, which can only be performed using the Data Owner, such as:

Changing the Schema of the data
Registering\Unregistering the data as Versioned
Granting privileges on that Data to other users in the geodatabase
Deleting the data, etc

Even though the 'sysadmin' is supposed to have the highest possible permissions on that SQL Server instance, it still cannot be used to perform the above tasks.

So in your case, if the data is owned by UserA (i.e DPI\UserA), then you will have to connect using the same DPI\UserA Windows login to delete the data. There are no other options.