Looking how to grant select on a whole database or owned schema at once. Don't really want to do it individually for thousands of layers.
I tried GRANT SELECT ON SCHEMA :: "schema" TO "user" and got an error
Check the Datareader role in SQL Server.
An overview of the db_datareader role
Database-level roles
See this documentation that I wrotehttps://desktop.arcgis.com/en/arcmap/latest/extensions/production-mapping-guide/admin-pm-sql-server/granting-privileges-to-the-production-mapping-workspace-components-in-sql-server.htm
Read my database guide books best practices and download my database template scripts, see link below.
https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351
did you get an error executing the grant statement in Management Studio, or did you get a specific error when the user tried to access the data on the schema you granted to?
Management Studio
what was the error? Are you using double-quotes around the schema & user name, and if so try dropping them.
I've started just granting privileges through the group layer in Pro to avoid the error. But it takes abut 10 minutes or so to do a group layer due to loading.
Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
