topic Re: Mass GRANT SELECT in Geodatabase Questions

Mass GRANT SELECT

Laura — Mon, 16 Jan 2023 21:30:25 GMT

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

Re: Mass GRANT SELECT

Asrujit_SenGupta — Tue, 17 Jan 2023 07:09:05 GMT

Check the Datareader role in SQL Server.

An overview of the db_datareader role

Database-level roles

Re: Mass GRANT SELECT

MarceloMarques — Tue, 17 Jan 2023 17:24:31 GMT

See this documentation that I wrote
https://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

Re: Mass GRANT SELECT

ShannonShields — Tue, 24 Jan 2023 19:37:27 GMT

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?

Re: Mass GRANT SELECT

Laura — Tue, 24 Jan 2023 19:46:26 GMT

Management Studio

Re: Mass GRANT SELECT

ShannonShields — Tue, 24 Jan 2023 19:54:27 GMT

what was the error? Are you using double-quotes around the schema & user name, and if so try dropping them.

Re: Mass GRANT SELECT

Laura — Tue, 24 Jan 2023 19:58:17 GMT

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.