Hello!
MY friend has a program, which should connect to a mssql databbase on Linux.
This program failed with error "Error HY010"
Sql-command was: "select filename from model.dbo.sysfiles" and "function sequence error"
Any ideas to fix that?
Tim
SA-user solved the problem, but which permissions was missing for normal user?
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!
Am 10.06.20 um 21:56 schrieb Erland Sommarskog:user
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
to model, it will be in every database!
Maybe I could clone settings from local MS SQL EE installation with
ships with this software.
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 63:03:14 |
Calls: | 6,654 |
Files: | 12,200 |
Messages: | 5,331,693 |