Latest Contributions by MKF62

I am doing a lot of reading about how to properly set up and configure user accounts in an SQL Server instance of an enterprise geodatabase, namely these three documents: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/user-accounts-groups.htm https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/add-users-sqlserver.htm https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm   We will be implementing an SDE-schema geodatabase. The SDE user will only be responsible for system tables and updates (and have the db_owner role). They will not be loading data and I'm trying to figure out how to create a "headless" user for that purpose. That way, if someone leaves our organization, the data sitting in our database isn't directly tied to that person's login. I believe this is possible, but I'm struggling to wrap my head around how SQL Server logins vs database users (and schemas) work.  This is what I'm envisioning. I would like a user on the database that can create and "own" all the data, this is called "DataOwner". There are three people who have their own logins, Billy, Bob, and Joe. I think those logins should be mapped to DataOwner so whenever they login, if they create a new feature class, it ends up being named MyGISData.DataOwner.FeatureClassX.      If I included making different roles for creation, editing, and viewing data, the diagram would end up looking more like this. You could have any number of SQL server logins mapped to a database user which is mapped to a role that has a particular set of privileges:     Is this possible? Is it advisable? If it's not, how do you get ahold of the data owned by someone else when that person leaves the organization? Or are people just creating logins and users like below and just letting multiple people use the same credentials (doesn't seem like a good security practice)?         I think most people set up their database something like this, but then you wind up with ownership of feature classes being tied to specific person which I'm trying to avoid:   ... View more

My website used to work, but now it no longer does. I have a custom web map set up with a proxy and I recently tried to publish it after moving our website to a new server and now it's giving me this error message:   {"error": {"code": 403,"message":"403 - Forbidden: Access is denied.","details":["message":"Current proxy configuration settings do not allow requests which do not include a referer header."]}}     I have my proxy code set up like this: In the javascript web map file:   //Set up the proxy to forward requests for data/geoprocessing tools urlUtils.addProxyRule({ urlPrefix: "https://www.mydomain.com", //For production environment (publishing) proxyUrl: "/myAppName/proxy/proxy.ashx" });     In my proxy.config file:   <ProxyConfig allowedReferers="https://www.mydomain.com/*" mustMatch="true" logFile="proxyLog.txt" logLevel="Warning"> <serverUrls> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/HabitatManagement/HabitatManagement/GPServer" username="username" password="password" matchAll="true"/> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/HabitatMonitoring/HabitatData/MapServer" username="username" password="password" matchAll="true" /> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/HabitatMonitoring/HabitatClassification/GPServer" username="username" password="password" matchAll="true" /> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/PrintHabitatMaps/PrintHabitatMap/GPServer" username="username" password="password" matchAll="true" /> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/ShipData/ShipData/GPServer" username="username" password="password" matchAll="true" /> <serverUrl url="https://www.mydomain.com/webadaptor/rest/services/Collector/FieldMapsHbData/GPServer" username="username" password="password" matchAll="true" /> </serverUrls> </ProxyConfig>     This is the request header for one of the map services trying to be reached:     This is the error info:   The proxyLog.txt file gives me this error. I'm don't really know anything about networks, but I don't understand why it says I have a null referer yet the request header has a value in referer??: The Proxy is being called by a null referer. Access denied.   ... View more

I have recently published a geoprocessing service and there is a path it replaces with the correct location on the server. I use a registered folder for my data and the publisher and server locations of that folder are different; this the path the g_ESRI_variable is attempting to replace. This is what the registered folder is set up as:   In my script, I have hardcoded the path needed to access files, this is the publisher folder path: workspace = r'E:\ArcGIS_RegisteredFolders_DO_NOT_DELETE\HabitatMapPrint'   The g_ESRI_variable being created and used to replace the above value for the workspace variable is this: g_ESRI_variable_4 = 'D:\\RegisteredFolders_DO_NOT_DELETE\\HabitatMapPrint't'   Note that it is adding t' to the end. I have no clue why, but it is causing an invalid syntax error if I try to run the geoprocessing tool from the server:   These are the settings when I overwrite the service:   I have also deleted the service and attempted to publish brand new, it doesn't make a difference. ... View more