Re: logged in user can't see tables

From: John Bell (jrm_bell@hotmail.com)
Date: 08/31/02 

From: John Bell <jrm_bell@hotmail.com>
Date: Sat, 31 Aug 2002 09:26:27 +0100

You don't say what the error messages are!

Are you connecting to the correct database?

What permissions does the user has on the tables?

John

On Sat, 31 Aug 2002 04:34:09 GMT, "pablo" <a@b.com> wrote:

>When I connect to my SQL 2000 database through a DSN in my .asp page using
>SQL authentication, I cannot see my tables without first prefixing them with
>the owner name. For example, my DSN is set to authenticate with a SQL
>id/pass:
>
>DSN=mydsn;UID=owner;pwd=xxx
>
>when I try and select on a table owned by owner
>
>SELECT * FROM employees
>
>fails, and
>
>SELECT * FROM owner.employees
>
>works.
>
>I tried the DSN without the UID and PWD, and the login fails, so I am sure I
>am loggin in correctly.
>
>I would like not to have to specifiy the owner prefix. Any ideas?
>
>

Relevant Pages

  • Re: logged in user cant see tables
    ... be qualified with the name of the object owner; ... SQL Server may not know which object to use because there could be ... >I assume I am connecting to the correct database, as when I select with the ... I just didn't expect I would HAVE to specify the ...
    (microsoft.public.sqlserver.security)
  • Re: logged in user cant see tables
    ... John, ... when I log in as the user 'paul', I still have to provide a owner name to ... The second link explains why the when 'paul' creates a table, ... >>login, defaults to the correct database, and, as I said before, fails ...
    (microsoft.public.sqlserver.security)
  • Re: logged in user cant see tables
    ... I assume I am connecting to the correct database, as when I select with the ... database with an employees table on my server). ... specify the the owner name. ... I just didn't expect I would HAVE to specify the ...
    (microsoft.public.sqlserver.security)