While scripting a few geoprocessing tools in python, I use the make feature layer tool to create virtual layers for further processing, such as add field. The script runs fine on data layers in a geodatabase, but when it hits layers in a sde, where I do not have write rights, the script bombs with an ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application.
I have set geoprocessing environments workspace and scratch workspace to the geodatabase where I have rights. This has not worked, so I am at a lost. I do not wish to copy the layer out of sde every time the script runs.
Thanks in advance for any ideas.
ed