ArcGIS - Python- Privs Scripts

MelissaStenger — Tue, 02 Oct 2012 16:57:14 GMT

I am new to ArcGIS.

We are using ArcGIS 10.0 .
We are sunning SQL 2008 R2 with SQL role based security connected to Active directory global groups.
We are connecting using the connection properties... sde:sqlserver:<servername\instance> with OS authentication.

We are in a rebuild mode, which requires the administrator to re-apply permissions to an average 50 items in catalog with more than 50 AD global groups for each item.

This is quite time consuming... ;(

Does anyone have a python script for doing this?

Melissa

Re: ArcGIS - Python- Privs Scripts

MathewCoyle — Sat, 11 Dec 2021 18:10:46 GMT

Not sure if this is what you are looking for. I use DB managed groups instead of AD users, so you will need to find a way to tap into AD to get your list of users to grant the privileges to and loop through them. The win32api or active_directory modules should be able to get what you want.

http://timgolden.me.uk/python/active_directory.html
http://www.python.org/getit/windows/

import arcpy
sde = r"sde_instance_path.sde"
arcpy.env.workspace = sde
fc_List = arcpy.ListFeatureClasses("some_filter")
fc_List.sort()
for fc in fc_List:
    try:
        print "Granting privileges to " + fc
        arcpy.ChangePrivileges_management(fc, "# group/user to grant priv", "GRANT")
    except:
        print "Passing " + fc
        pass

topic ArcGIS - Python- Privs Scripts in Python Questions

ArcGIS - Python- Privs Scripts

Re: ArcGIS - Python- Privs Scripts