SELECT not qualifing owner

[mingus]

Okay I tried to make some updates to my database and I messed something up!


I used to be able to say:

SELECT * FROM my_table.

Now I required with the same login in to say:

SELECT * FROM owner.my_table

The trouble is the application I am using does things the first way and it is not connection correctly, so I can't live with this.

I am logging in as the owner of the table, but I guess there is another trick to this.

thanks,

mingus

 

[tlbroadbent]

Have you set the login as a system administrator? If so, you'll ned to use the owner qualifier even if the login is the owner because the SA always uses dbo as the the object owner unless explicitly provided.

PRB: Owner of a Table Cannot Access It Directly If Made Sysadmin After Creation

http://support.microsoft.com/support/kb/articles/Q255/0/67.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mingus]

Thanks! Who'd thought that was the cause (not me obviously!)

 

[tlbroadbent]

It caught me several months ago and had me baffled for a while. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.