https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1563079#M73253 <P>I'm building a tool that involves creating a table in an enterprise geodatabase and applying privileges. I'd like the user to pick which role they want to apply for the privileges, but I can't figure out how to get a list of current roles for them to choose from. Is this possible?</P> Wed, 27 Nov 2024 17:47:23 GMT AlfredBaldenweck 2024-11-27T17:47:23Z https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1563079#M73253 <P>I'm building a tool that involves creating a table in an enterprise geodatabase and applying privileges. I'd like the user to pick which role they want to apply for the privileges, but I can't figure out how to get a list of current roles for them to choose from. Is this possible?</P> Wed, 27 Nov 2024 17:47:23 GMT https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1563079#M73253 AlfredBaldenweck 2024-11-27T17:47:23Z https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654155#M74747 <P>Can you use&nbsp;<A href="https://pro.arcgis.com/en/pro-app/latest/arcpy/functions/listusers.htm" target="_blank">ListUsers—ArcGIS Pro | Documentation</A>&nbsp;in the validation script and output the list in the filter list of the parameter? Guess you'll need to be signed in as admin.</P> Tue, 30 Sep 2025 13:36:30 GMT https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654155#M74747 MattHowe 2025-09-30T13:36:30Z https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654178#M74748 <P>No dice; it looks like that only shows active connections and I was looking for specific groups, if I remember correctly. I think I ended up hardcoding it into the script based on which groups the user running the script belonged to, or opening it to all the users in the organization by default and letting whoever was using the script set privileges after the fact.</P><P>Thank you for the suggestion, though; I hadn't thought to try that.</P> Tue, 30 Sep 2025 14:12:13 GMT https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654178#M74748 AlfredBaldenweck 2025-09-30T14:12:13Z https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654179#M74749 <P>No probs. This might help -&nbsp;<A href="https://community.esri.com/t5/arcgis-enterprise-questions/list-database-users/td-p/1488522" target="_blank">List Database Users - Esri Community</A></P> Tue, 30 Sep 2025 14:15:05 GMT https://community.esri.com/t5/python-questions/sde-connection-file-get-list-of-all-roles/m-p/1654179#M74749 MattHowe 2025-09-30T14:15:05Z