Re: logged in user can't see tables

From: pablo (a@b.com)
Date: 08/31/02 

From: "pablo" <a@b.com>
Date: Sat, 31 Aug 2002 20:34:50 GMT

Interestingly enough, after a bunch of searching, I found this exchange on a
web site started by a guy haveing the same problem. The solution, change
the owner to dbo for all the tables is not optimal for me.

http://www.sqlmag.com/Forums/messageview.cfm?catid=3&threadid=7107

-Paul

"John Bell" <jrm_bell@hotmail.com> wrote in message
news:sav0nug92m2psme0cosv0fnsn7nrf36rlg@4ax.com...
> 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
    ... it is created with owner dbo. ... I cannot see my tables without first prefixing them ... my DSN is set to authenticate with a SQL ... >>>I tried the DSN without the UID and PWD, and the login fails, so I am ...
    (microsoft.public.sqlserver.security)
  • Re: logged in user cant see tables
    ... Even when I log in as user 'paul', ... it is created with owner dbo. ... my DSN is set to authenticate with a SQL ... >>I tried the DSN without the UID and PWD, and the login fails, so I am ...
    (microsoft.public.sqlserver.security)
  • Re: bcp invalid object name
    ... You need to have the owner in between the db and the object, ... or, since dbo is one of the default owners, you can leave it out, but you ... Kalen Delaney, SQL Server MVP ... Login fails. ...
    (microsoft.public.sqlserver.tools)