Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #2047
| Path | csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Error HY010 |
| Date | Thu, 11 Jun 2020 20:40:57 +0200 |
| Organization | Erland Sommarskog |
| Lines | 20 |
| Message-ID | <XnsABD9D2651A550Yazorman@127.0.0.1> (permalink) |
| References | <rbqf0v$uk4$1@tota-refugium.de> <rbrcc5$on9$1@tota-refugium.de> <XnsABD8DF4213D53Yazorman@127.0.0.1> <rbsv3e$ubt$1@tota-refugium.de> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | reader02.eternal-september.org; posting-host="8fb76a8e7458ef31ad142b53d00cba1a"; logging-data="4009"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/E2zkzfu1naQjpPbNnL8p3" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:TyrK1qMYLGzy4oS9mSvQgVnoaAs= |
| Xref | csiph.com comp.databases.ms-sqlserver:2047 |
Show key headers only | View raw
Tim Ritberg (tim@server.invalid) writes: > Am 10.06.20 um 21:56 schrieb Erland Sommarskog: >> Tim Ritberg (tim@server.invalid) writes: >>> SA-user solved the problem, but which permissions was missing for normal >>> user? >>> >> >> Plain users do normally not have permissions in model. You can add users >> and grant permissions, but it is not a good idea. To wit, when you create >> a new database, SQL Server copies the files for model. So if you had a user >> to model, it will be in every database! >> > > Maybe I could clone settings from local MS SQL EE installation with > ships with this software. Just to clarify: this is "problem" should not be fixed, unless there is some very special reason. model is a very special database, and it is very uncommon to run queries against it.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Error HY010 Tim Ritberg <tim@server.invalid> - 2020-06-10 13:09 +0200
Re: Error HY010 Tim Ritberg <tim@server.invalid> - 2020-06-10 21:30 +0200
Re: Error HY010 Erland Sommarskog <esquel@sommarskog.se> - 2020-06-10 21:56 +0200
Re: Error HY010 Tim Ritberg <tim@server.invalid> - 2020-06-11 11:56 +0200
Re: Error HY010 Erland Sommarskog <esquel@sommarskog.se> - 2020-06-11 20:40 +0200
Re: Error HY010 rja.carnegie@gmail.com - 2020-06-11 12:30 -0700
csiph-web