topic Re: Level 1 Users Cannot Access Referenced Data in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/level-1-users-cannot-access-referenced-data/m-p/341842#M13118 <HTML><HEAD></HEAD><BODY><P>Here is the answer:</P><P>The original view was published using an SDE connection with a user that had write capabilities enabled.&nbsp; Portal didn't give level 1 users access to the data because of this.&nbsp; A new database user had to be created with read only access to the database.&nbsp; The new SDE connection with the read only user was registered with the AGS and a new service was published with the view added to ArcMap using that read only connection.&nbsp; The old feature service was replaced in the webmaps/dashboards with the newly published service so that level 1 users could access the data.</P><P></P><P>Note:&nbsp; The old service could not simply be overwritten using this new connection.&nbsp; It would not update the service properties.&nbsp; A new feature service had to be created in order for it to work.</P></BODY></HTML> Fri, 24 Jan 2020 17:54:16 GMT Anonymous User 2020-01-24T17:54:16Z Level 1 Users Cannot Access Referenced Data https://community.esri.com/t5/arcgis-enterprise-questions/level-1-users-cannot-access-referenced-data/m-p/341841#M13117 <HTML><HEAD></HEAD><BODY><P>I have an ArcGIS Enterprise 10.5 environment with a SQL server Enterprise Geodatabase.&nbsp; Most of the users of Portal are Level 2 publishers or creators.&nbsp; There have been numerous apps and dashboards created using published, referenced feature layers using data from the SDE with no access issues until now.</P><P></P><P>With a recently created feature service and Dashboard I have a small group of level 1 viewers who cannot load the feature service in either the dashboard or a stand alone web map.&nbsp; They can see the feature service since it is shared to the group that they are in, but when a level one user attempts to load the feature layer in a web map they receive the error message saying the data could not be loaded into the map.</P><P></P><P>Here are the details about the layer.&nbsp; It is a SQL view of one spatial and one non-spatial table both in the same database.&nbsp; Neither of the tables are versioned.&nbsp; It is published to Portal using ArcMap 10.5 as referenced data.&nbsp; All level 2 users can access it and use the Dashboard that contains it.&nbsp; My thoughts are that it has something to do with permissions on the tables in the database, but I don't know exactly.</P></BODY></HTML> Fri, 24 Jan 2020 13:31:11 GMT https://community.esri.com/t5/arcgis-enterprise-questions/level-1-users-cannot-access-referenced-data/m-p/341841#M13117 Anonymous User 2020-01-24T13:31:11Z Re: Level 1 Users Cannot Access Referenced Data https://community.esri.com/t5/arcgis-enterprise-questions/level-1-users-cannot-access-referenced-data/m-p/341842#M13118 <HTML><HEAD></HEAD><BODY><P>Here is the answer:</P><P>The original view was published using an SDE connection with a user that had write capabilities enabled.&nbsp; Portal didn't give level 1 users access to the data because of this.&nbsp; A new database user had to be created with read only access to the database.&nbsp; The new SDE connection with the read only user was registered with the AGS and a new service was published with the view added to ArcMap using that read only connection.&nbsp; The old feature service was replaced in the webmaps/dashboards with the newly published service so that level 1 users could access the data.</P><P></P><P>Note:&nbsp; The old service could not simply be overwritten using this new connection.&nbsp; It would not update the service properties.&nbsp; A new feature service had to be created in order for it to work.</P></BODY></HTML> Fri, 24 Jan 2020 17:54:16 GMT https://community.esri.com/t5/arcgis-enterprise-questions/level-1-users-cannot-access-referenced-data/m-p/341842#M13118 Anonymous User 2020-01-24T17:54:16Z