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
See this documentation that I wrote
Read my database guide books best practices and download my database template scripts, see link below.
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?
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.