idea Drop Database User tool in Data Management Ideas

Drop Database User tool

SeikoHIMIYAMA — Fri, 26 Aug 2022 00:14:08 GMT

On ArcGIS for Desktop, we can use Create Database User tool.

Sometimes we need to drop database user. Currently we need use DBMS Utilities to drop database user.
It would be greate that we can drop database user from ArcGIS for Desktop.

Re: Drop Database User tool

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

Hellpo Seiko,

A few lines to make your case stronger, if necessary:

We have the same case here, having created users with ArcGIS (therefiore also schemas in the underlying PGSQL RDMS).

We would need a tool for a clean & easy deletion of these users (and schemas) using ArcGIS or ArcPy.

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.

This capability already exists, but for Oracle-based SDE geodatabases only. What we are asking for here is the same tool for other types of underlying RDMS (PostresSSQL in my case).

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

Best regards,

Hélène.

Re: Drop Database User tool

JamalNUMAN — Sat, 20 Feb 2021 09:26:43 GMT

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

Re: Drop Database User tool

feralcatcolonist — Tue, 23 May 2023 14:29:43 GMT

I would love to hear the rationale for not including this; since deleting a user (or group) was never a tool in ArcMap, I'm assuming there is some rationale?

This would be a nice quality of life addition for geodatabase administrators that have less direct access to their database environment and rely on a DBA to make those changes.