Select to view content in your preferred language

SDE connection file: get list of all roles?

271
3
11-27-2024 09:47 AM
AlfredBaldenweck
MVP Regular Contributor

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?

3 Replies
MattHowe
Frequent Contributor

Can you use ListUsers—ArcGIS Pro | Documentation 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.

AlfredBaldenweck
MVP Regular Contributor

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.

Thank you for the suggestion, though; I hadn't thought to try that.

0 Kudos
MattHowe
Frequent Contributor

No probs. This might help - List Database Users - Esri Community