Re: invalid object name

Tech-Archive recommends: Fix windows errors by optimizing your registry

paolo.ricci_at_gidi.it
Date: 09/07/04 

Date: Tue, 7 Sep 2004 06:38:16 -0700

Bingo Dan ! "lisa" is a member of sysadmin role and the
statement "select user" return "dbo".
Is it possible to select from tables owned by "lisa"
without specified the owner ? I can't disable sysadmin
role for lisa !
Thank you !!!
Bye Paolo.
 
>-----Original Message-----
>Is 'lisa' a member of the sysadmin role? In this case,
the default owner
>will be 'dbo' instead of 'lisa' when resolving object
names. You can
>determine the name used for object name resolution with
SELECT USER.
>
>--
>Hope this helps.
>
>Dan Guzman
>SQL Server MVP
>
>"paolo" <paolo.ricci@gidi.it> wrote in message
>news:746e01c494d7$50f799a0$a501280a@phx.gbl...
>> In my database I have created a table called "com01"
owned
>> by "lisa" and if I try to select the rows with the
>> statement "select * from lisa.com01" it works fine !
>> But if I submit the statement "select * from com01" it
>> return the error:
>> Server: Msg 208, Level 16, State 1, Line 1
>> Invalid object name 'com01'.
>> Why ??
>> In both cases I'm connected to the database with
>> user "lisa" who is the owner of the table. There isn't
>> other table called "com01" in the database.
>> Help me please !!!
>>
>>
>
>
>.
>

Relevant Pages