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 18:56:20 GMT

John,

I am sorry. You are absolutely right. It was very late and I was tired of
working on this for so long.

The error I get with the "SELECT * FROM employees" (without the table owner
name) is:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'employees'.

I assume I am connecting to the correct database, as when I select with the
owner name prefixed, I get the expected data back (and there is no other
database with an employees table on my server).

The user has full permissions on all tables. I can read it fine when I
specify the the owner name. I just didn't expect I would HAVE to specify the
owner name, as I am connected as said owner.

I have quadruple-checked the DSN, and it specifies to connect with SQL
login, defaults to the correct database, and, as I said before, fails login
unless I specify the user that is the owner of the table.

One thing that I have noticed is that when I connect to the database using
SEM, it appears that, although I registered to connect as the same user
mentioned above, when I try and run queries without the owner prefix, I get
the same Invalid Object Name error message. It is as if I am logging in as
sa, even though I have logged in as 'paul' (which it the real username).

Thanks for your help.

-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
    ... 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: conflicting object names in sql server 2000
    ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
    (microsoft.public.sqlserver.server)
  • Re: PayPal - Meet IRS!
    ... As long-time B&M business owner, I can echo some of this. ... There are some expense account perks that can be ... I had 40+ employees, and employees can be a headache (as well ...
    (alt.marketing.online.ebay)
  • Re: Minnesota Bars Beat Smoking Ban
    ... Servers and other employees are being hurt by this purposeful disregard of the law. ... They are using tricks to get around a legal requirement that limits smoking to theatrical roles. ... That is not a good reason for employers not to protect or to follow the law. ... But it should be up to the OWNER of the establishment, ...
    (alt.true-crime)
  • Re: Haas CNC Racing owner to plead guilty to tax charges
    ... Back taxes, a $5 million fine, fraud penalties of 40% and interest will bring Mr. Haas’s total cost for cheating on his 2000 and 2001 taxes to more than $70 million. ... Mr. Haas paid three employees or associates, who have already pleaded guilty, 2 percent of what he avoided paying in taxes, according to court papers. ...
    (alt.machines.cnc)