Python script to list Privileges in Geodatabase by Feature Class

Question

Hello.

I am having no luck finding a python snippet or example of how to list out privileges for the geodatabase. ChatGPT hasn't provided accurate coding either. If anyone can share how to do this then I would be very appreciative.  We use SQL server.

Thank you.

ShariF · Answer

Thank you. I found that article too but had no luck getting it to work.  Maybe with arcpy.ARCSDESQExecute  and the previous answer provided I can get something working.

ShariF · Answer

Thank you. I'm a newbie with SQL server studio and will give this a try.

Marcelo Marques · Answer

@ShariF - see this python script example, it might give you some ideas.
https://gis.stackexchange.com/questions/73991/checking-current-user-privileges-for-arcsde-dataset-with-arcpy
This article is quite old though. But take a look at the arcpy API documentation, it might have some new method available.
https://developers.arcgis.com/python/api-reference/

If you do not find what you are looking for then I encourage you to open a support ticket with Esri Technical Support.