topic Python Script Set Dataset permission Error in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26435#M936 <HTML><HEAD></HEAD><BODY><SPAN>I try to run Python scrip(10.1) to set network dataset permission but get error.does anyone know why?</SPAN><BR /><BR /><SPAN>here is the Python code:arcpy.ChangePrivileges_management(targetDBConn +"Transportation",</SPAN><BR /><SPAN> "GISVEC1_APP_RL", "GRANT", "GRANT")</SPAN><BR /><BR /><SPAN>Here is the error message:ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Incorrect syntax near '-'.]</SPAN><BR /><SPAN>Failed to execute (ChangePrivileges).</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 19 Mar 2013 17:48:51 GMT ZhanGao 2013-03-19T17:48:51Z Python Script Set Dataset permission Error https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26435#M936 <HTML><HEAD></HEAD><BODY><SPAN>I try to run Python scrip(10.1) to set network dataset permission but get error.does anyone know why?</SPAN><BR /><BR /><SPAN>here is the Python code:arcpy.ChangePrivileges_management(targetDBConn +"Transportation",</SPAN><BR /><SPAN> "GISVEC1_APP_RL", "GRANT", "GRANT")</SPAN><BR /><BR /><SPAN>Here is the error message:ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Incorrect syntax near '-'.]</SPAN><BR /><SPAN>Failed to execute (ChangePrivileges).</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 19 Mar 2013 17:48:51 GMT https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26435#M936 ZhanGao 2013-03-19T17:48:51Z Re: Python Script Set Dataset permission Error https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26436#M937 <HTML><HEAD></HEAD><BODY><SPAN>I'm guessing that you need a forward slash between your database path and the feature-class name?</SPAN></BODY></HTML> Sat, 23 Mar 2013 17:24:37 GMT https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26436#M937 DuncanHornby 2013-03-23T17:24:37Z Re: Python Script Set Dataset permission Error https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26437#M938 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I'm guessing that you need a forward slash between your database path and the feature-class name?</BLOCKQUOTE><BR /><BR /><SPAN>my targeDBConn is "D:\\DBConnections\\DEVGISStaging_gisvec1_owner.sde\\gisvec1.OC." + "Transportation"</SPAN></BODY></HTML> Mon, 25 Mar 2013 17:35:13 GMT https://community.esri.com/t5/geoprocessing-questions/python-script-set-dataset-permission-error/m-p/26437#M938 ZhanGao 2013-03-25T17:35:13Z