Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #2036 > unrolled thread

Error HY010

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  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

#2036 — Error HY010

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

[toc] | [next] | [standalone]

#2038

Am 10.06.20 um 13:09 schrieb Tim Ritberg:
> 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

[toc] | [prev] | [next] | [standalone]

#2040

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!

[toc] | [prev] | [next] | [standalone]

#2046

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.

Tim

[toc] | [prev] | [next] | [standalone]

#2047

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.

[toc] | [prev] | [next] | [standalone]

#2049

On Thursday, 11 June 2020 19:41:00 UTC+1, Erland Sommarskog  wrote:
> 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.

Perhaps the intention is to run on a user database, 
and "model" was chosen as an example.  

If I'm following this, the specific statement is 
looking for the file names in the filesystem that 
contain the database data, and I wonder why you'd
want that from "model", which only exists so that
you can say "create database" and make a copy of it, 
maybe on different filesystems.  You would want to 
back up model, I suppose.  (People do that for me.  :-)
(...I hope.)

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web