topic How to re-assign 'select' after FME drops a table? in Data Management Questions https://community.esri.com/t5/data-management-questions/how-to-re-assign-select-after-fme-drops-a-table/m-p/35572#M1996 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>To update our Production 10.1 SDE I give my DBA a model that he has to enter his username and password into, then when he runs it, it runs any number of FME ETL tools from within the Toolbox that I have configured and will load the data as needed, with parameters exposed for the username and password the DBA will enter.</SPAN><BR /><BR /><SPAN>The problem I'm having is when we 'drop' a table because there is a schema-change, FME re-creates it and loads the data, but the re-created table is invisible to the 'GIS-read' user until the DBA re-assigns 'select' privileges via ArcCatalog. </SPAN><BR /><BR /><SPAN>The process of re-assigning the 'select' privileges is what we want to replace with an automated process that I can configure in the model the DBA runs with the FME tools.</SPAN><BR /><BR /><SPAN>Is there a geoprocessing tool that will do what the 'privileges' GUI in ArcCatalog does?</SPAN><BR /><BR /><SPAN>Any thoughts appreciated!</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>-m</SPAN></BODY></HTML> Tue, 24 Jun 2014 19:19:12 GMT MatthewBaker2 2014-06-24T19:19:12Z How to re-assign 'select' after FME drops a table? https://community.esri.com/t5/data-management-questions/how-to-re-assign-select-after-fme-drops-a-table/m-p/35572#M1996 <HTML><HEAD></HEAD><BODY><SPAN>Hi all,</SPAN><BR /><BR /><SPAN>To update our Production 10.1 SDE I give my DBA a model that he has to enter his username and password into, then when he runs it, it runs any number of FME ETL tools from within the Toolbox that I have configured and will load the data as needed, with parameters exposed for the username and password the DBA will enter.</SPAN><BR /><BR /><SPAN>The problem I'm having is when we 'drop' a table because there is a schema-change, FME re-creates it and loads the data, but the re-created table is invisible to the 'GIS-read' user until the DBA re-assigns 'select' privileges via ArcCatalog. </SPAN><BR /><BR /><SPAN>The process of re-assigning the 'select' privileges is what we want to replace with an automated process that I can configure in the model the DBA runs with the FME tools.</SPAN><BR /><BR /><SPAN>Is there a geoprocessing tool that will do what the 'privileges' GUI in ArcCatalog does?</SPAN><BR /><BR /><SPAN>Any thoughts appreciated!</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>-m</SPAN></BODY></HTML> Tue, 24 Jun 2014 19:19:12 GMT https://community.esri.com/t5/data-management-questions/how-to-re-assign-select-after-fme-drops-a-table/m-p/35572#M1996 MatthewBaker2 2014-06-24T19:19:12Z