topic List Database Users in ArcGIS Enterprise Questions

List Database Users

TylerT — Mon, 10 Jun 2024 21:17:37 GMT

Hello,

I am using Create Database User here:
https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-database-user.htm

and now have the need to list these same database users. Is there a tool for listing database users?

I see this tool... https://pro.arcgis.com/en/pro-app/latest/arcpy/functions/listusers.htm but this seems to list a different type of user (a connected user by id).

Thank you,

Tyler

Re: List Database Users

ChrisUnderwood — Thu, 13 Jun 2024 13:44:56 GMT

Hello @TylerT , the Create Database User tool makes the user in the database itself, it doesn't create anything on the Esri side. So the best way to list all the database users is from the database side, eg using SQL, or a database management tool.

From ArcGIS Pro, you can use the Catalog pane to right-click on a Feature Class you own. Then select Privileges > Add User. That will return a form showing the database users, which might meet your needs.

Re: List Database Users

George_Thompson — Thu, 13 Jun 2024 13:56:56 GMT

SELECT * FROM sys.database_principals

This code in SQL should return all the user names in a specific database. This would include DB roles, etc.