topic Re: Delete database user? in ArcGIS Enterprise Questions

Delete database user?

PaulHuffman — Tue, 22 Jun 2021 08:41:52 GMT

I used Administration>Add User in ArcCatalog 10.5.1 using a sa connection to an enterprise database based on Windows, ArcServer 10.3.1, SQL Server 2016 RC3 to add a user named "temp" for a demonstration. Now I want to delete user "temp", but I can't figure out how. I tried with SSMS, but it reported it was unable, that there was also a schema named "temp". Was "temp" an unfortunate name choice, or do I want to also delete this schema?

All I could find was this suggestion for a Drop tool. https://community.esri.com/ideas/9405

Re: Delete database user?

HélèneTouyéras — Mon, 30 Mar 2020 09:47:16 GMT

Hi Paul,

Did you ever clear this? We have the same case here, having created users with ArcGIS (therefiore also schemas in the underlying PGSQL RDMS).

Is there a way for a clean & easy deletion of these users (and schemas) using ArcGIS, ArcPy, or -as a last resort- ArcObjects?

I do not particulalry want to delete the schema in PgAdmin, as I guess there would remain traces of it somewhere deep in the SDE schema of that database.

ESRI people, any advice welcome - many, many thanks!!

Best regards,

Hélène.

Re: Delete database user?

JamalNUMAN — Sat, 20 Feb 2021 09:23:59 GMT

Not sure if the Pro has a tool to delete the database user or the only way to do it is from SQL server