After mass loading a bunch of feature classes into a enterprise geodatabases (10.3.1, MSSQL), I need to add privileges for a role to many of them. I tested ChangePrivileges with a single feature class, it worked, so now I thought I would extend this by getting a list of feature classes, then using a For loop on the list to grant the privileges. But it didn't wok to set up the correct database connection as a env.workspace. What's the correct way to loop through a enterprise geodatabase to add permissions? Or do I want to do this in a totally different way? The following script gives a TypeError: 'NoneType' object is not iterable on debugging line 17, indicating I didn't get anything into the list. # ModPriv2lp.py # Testing how to modify enterprise geodatabase privileges with python # Paul Huffman, 2017-12-14 import arcpy from arcpy import env env . workspace = "Database Connections/Streams as GisOwner.sde" #get list of feature classes in geodatabase. fclist = [ ] fclist = arcpy . ListFeatureClasses ( "Database Connections/Streams as GisOwner.sde" ) #datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers" #datasetName = "Streams.GISOWNER.str37_route_rivers" #arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS") for fc in fclist : print fc #arcpy.ChangePrivileges_management(fc, "GISUsers", "GRANT", "AS_IS")

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Do I want to set the database connection as an environment in order to loop through feature classes?

PaulHuffman

After mass loading a bunch of feature classes into a enterprise geodatabases (10.3.1, MSSQL), I need to add privileges for a role to many of them. I tested ChangePrivileges with a single feature class, it worked, so now I thought I would extend this by getting a list of feature classes, then using a For loop on the list to grant the privileges. But it didn't wok to set up the correct database connection as a env.workspace. What's the correct way to loop through a enterprise geodatabase to add permissions? Or do I want to do this in a totally different way? The following script gives a TypeError: 'NoneType' object is not iterable on debugging line 17, indicating I didn't get anything into the list.

<SPAN class="comment token"># ModPriv2lp.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token"># Paul Huffman, 2017-12-14</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#datasetName = "Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS")</SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fclist<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fc
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#arcpy.ChangePrivileges_management(fc, "GISUsers", "GRANT", "AS_IS")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Finde mehr Beiträge mit dem Tag

Accepted answers

JakeSkinner

When using print with Python 3.x, you will want to put parenthesis around the print statement:

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Print message"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

PaulHuffman

I got this to run in ModelBuilder with iteration, but unfortunately, the export to python isn't much help in figuring out the python syntax for the workspace environment.

JakeSkinner

Hi Paul,

Once you set your environment workspace, the List functions (i.e. ListFeatureClasses, ListDatasets, etc) will automatically use that workspace. You're trying to set the workspace in the ListFeatureClasses function for the wild card parameter. Try the following:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulHuffman

Thanks Jake. But I have tried that syntax as well. Still getting the error " for fc in fclist:
TypeError: 'NoneType' object is not iterable"

<SPAN class="comment token"># -*- coding: utf-8 -*-</SPAN>
<SPAN class="comment token"># ModPriv2lp.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token"># Paul Huffman, 2017-12-14</SPAN>

<SPAN class="comment token"># Set the necessary product code</SPAN>
<SPAN class="keyword token">import</SPAN> arceditor

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#fclist = arcpy.ListFeatureClasses ("Database Connections/Streams as GisOwner.sde")</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#The folling line worked by setting connection + feature class in a string for ChangePrivileges</SPAN>
<SPAN class="comment token">#datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#datasetName = "Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS")</SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fclist<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fc
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#arcpy.ChangePrivileges_management(fc, "GISUsers", "GRANT", "AS_IS")</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JakeSkinner

Check the Streams as GisOwner.sde connection is connected as the correct user. You can do this by right-clicking on the database connection > Connection Properties. It could be the user does not have privileges to any of the feature classes.

JoshuaBixby

I am not sure what the best way is, but I would say the most Pythonic way is using Walk—Help | ArcGIS Desktop

PaulHuffman

Thanks Jake, but it worked when I ran a script like this on just one feature class. There must be a typo somewhere.

<SPAN class="comment token"># ModPriv.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token">#Paul Huffman, 2017-12-14</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy

datasetName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>datasetName<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GISUsers"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulHuffman

Hey, I've used Walk before. I'll give it a try in this situation.

PaulHuffman

Here's an idea. I just tried the three line version of the script from IDLE, and still get "ERROR 000229: Cannot open Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers." Yet I can copy those three lines into ArcCatalog's python window and it successfully ran. And the model with iterator version runs successfully. Do you suppose that setting datasetName = "'Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers'" in IDLE isn't working because that connection string doesn't mean anything to the OS, the OS can't find that connection, while running it in ArcCatalog can find the correct relative path and connection? Dropbox - Screenshot 2017-12-18 15.21.59.png

PaulHuffman

I tried it with walk. Almost the same thing, although the walk version ran without errors from IDLE, the feature class list was empty, and permissions were not updated. If I copy and paste the python lines into ArcCatalog Python window, the lines run to completion, the print filename line shows the current feature class getting processed, and the privileges get added. It's as if the Database connection is a property that only ArcCatalog knows about. Arcpy and os don't know about the database connections.

<SPAN class="comment token"># -*- coding: utf-8 -*-</SPAN>
<SPAN class="comment token"># ModPrivlpwalk.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token">#&nbsp; this time with python Walk rather than ListFeatureClass</SPAN>
<SPAN class="comment token"># Paul Huffman, 2017-12-18</SPAN>

<SPAN class="comment token"># Set the necessary product code</SPAN>
<SPAN class="keyword token">import</SPAN> arceditor
<SPAN class="keyword token">import</SPAN> os

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN>
ws <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
walk <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Walk<SPAN class="punctuation token">(</SPAN>ws<SPAN class="punctuation token">,</SPAN> datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"FeatureClass"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#fclist = arcpy.ListFeatureClasses ("Database Connections/Streams as GisOwner.sde")</SPAN>
<SPAN class="comment token">#fclist = arcpy.ListFeatureClasses ()</SPAN>

<SPAN class="comment token">#The folling line worked by setting connection + feature class in a string for ChangePrivileges</SPAN>
<SPAN class="comment token">#datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#datasetName = "Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS")</SPAN>

<SPAN class="comment token">#for fc in fclist:</SPAN>
<SPAN class="keyword token">for</SPAN> dirpath<SPAN class="punctuation token">,</SPAN> dirnames<SPAN class="punctuation token">,</SPAN> filenames <SPAN class="keyword token">in</SPAN> walk<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> filenames<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> filename
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>filename<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GISUsers"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulHuffman

I asked ESRI, and Rex found the correct syntax for adding a enterprise geodatabase connection as a env.workspace. to get this to run outside of ArcGIS Desktop, you need to read in the connection file. But you must also ensure that the connection is made with the "Save username / password" option checked in the connection properties. Otherwise, the connection will try to promprt you for the username/password, and fail in a script.

To find the connection file path, " in ArcCatalog- right click the connection file < Properties < Copy the file path). " In my case this was C:\Users\huffm\AppData\Roaming\Esri\Desktop10.3\ArcCatalog\Streams as GisOwner.sde. Knowing this will open up all kinds of SDE geodatabase management and processing for me. Couldn't find this anywhere in Help. Also note, env.Workspace doesn't work, it needs to be env.workspace.

In this script, you can see several ways I tried to get the syntax correct that in the commented out in lines 12 - 14, then the last env.workspace in line 15 is the correct way, going to the connection file. This script successfully populates the fclist, and prints list elements out to the Python Shell. Remove the comment on line 29 and it will grant privileges to everything in the geodatabase connection.

<SPAN class="comment token"># -*- coding: utf-8 -*-</SPAN>
<SPAN class="comment token"># ModPriv2lp.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token"># Paul Huffman, 2017-12-14</SPAN>

<SPAN class="comment token"># Set the necessary product code</SPAN>
<SPAN class="keyword token">import</SPAN> arceditor
<SPAN class="keyword token">import</SPAN> os

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="comment token">#env.workspace = "Database Connections/Streams as GisOwner.sde"</SPAN>
<SPAN class="comment token">#env.workspace = "Database Connections\\Streams as GisOwner.sde"</SPAN>
<SPAN class="comment token">#env.workspace = r"Database Connections\Streams as GisOwner.sde"</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Users\huffm\AppData\Roaming\Esri\Desktop10.3\ArcCatalog\Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#fclist = arcpy.ListFeatureClasses ("Database Connections/Streams as GisOwner.sde")</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#The folling line worked by setting connection + feature class in a string for ChangePrivileges</SPAN>
<SPAN class="comment token">#datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#datasetName = "Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS")</SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fclist<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fc
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#arcpy.ChangePrivileges_management(fc, "GISUsers", "GRANT", "AS_IS")</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulHuffman

I was just running this script at another office, and extending it to include other data besides feature classes, and it was running like a champ. Today I noticed it was running without reading my connection file, but just getting the connection from ArcCatalog. I think the difference is that I was finding the python file with File Explorer, right clicking on it, I get choices that include Edit with IDLE, Edit with IDLE (ArcGIS Pro), Run with ArcGIS Pro. If I select "Edit with IDLE", I think it gets opened in an ArcDesktop type environment, because it doesn't have any problem finding and importing arcpy, and the env.workspace can be set with the same string that ArcCatalog knows for my data owner connection. The slash in the Database Connections string can be either way / or \ .

<SPAN class="comment token"># -*- coding: utf-8 -*-</SPAN>
<SPAN class="comment token"># ModPriv2lp.py</SPAN>
<SPAN class="comment token"># Testing how to modify enterprise geodatabase privileges with python</SPAN>
<SPAN class="comment token"># Paul Huffman, 2017-12-14</SPAN>

<SPAN class="comment token"># Set the necessary product code</SPAN>
<SPAN class="comment token">#import arceditor</SPAN>
<SPAN class="keyword token">import</SPAN> os

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
<SPAN class="comment token">#env.workspace = "Database Connections/Streams as GisOwner.sde"</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections/Other_Vector as GIS.sde"</SPAN>
<SPAN class="comment token">#env.workspace = "Database Connections\\Streams as GisOwner.sde"#env.workspace = r"Database Connections\Streams as GisOwner.sde"</SPAN>

<SPAN class="comment token">#get list of feature classes in geodatabase.</SPAN>
fclist <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">#fclist = arcpy.ListFeatureClasses ("Database Connections/Streams as GisOwner.sde")</SPAN>
fclist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
dslist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListDatasets <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
tblist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListTables <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
rslist <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListRasters <SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#The folling line worked by setting connection + feature class in a string for ChangePrivileges</SPAN>
<SPAN class="comment token">#datasetName = "Database Connections/Streams as GisOwner.sde/Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#datasetName = "Streams.GISOWNER.str37_route_rivers"</SPAN>
<SPAN class="comment token">#arcpy.ChangePrivileges_management(datasetName, "GISUsers", "GRANT", "AS_IS")</SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fclist<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> fc
    arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DataViewer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> ds <SPAN class="keyword token">in</SPAN> dslist<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> ds
    arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>ds<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DataViewer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> tb <SPAN class="keyword token">in</SPAN> tblist<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> tb
    arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>tb<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DataViewer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> rs <SPAN class="keyword token">in</SPAN> rslist<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">print</SPAN> rs
    arcpy<SPAN class="punctuation token">.</SPAN>ChangePrivileges_management<SPAN class="punctuation token">(</SPAN>rs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DataViewer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"GRANT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"AS_IS"</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

PaulHuffman

When I try to open a script like this with the "Edit with IDLE (ArcGIS Pro)" choice in File Explorer, I get Python 3.6.5 and the script fails with syntax error, missing parenthesis in print statement. Is print totally different in Python 3.6.5?

JakeSkinner

When using print with Python 3.x, you will want to put parenthesis around the print statement:

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Print message"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.