logged in user can't see tables
From: pablo (a@b.com)
Date: 08/31/02
- Next message: Oskar: "execute a stored job through MS ACCESS 2000"
- Previous message: Bill: "SQL Server 2000 Login Security / Permissions"
- Next in thread: John Bell: "Re: logged in user can't see tables"
- Reply: John Bell: "Re: logged in user can't see tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "pablo" <a@b.com> Date: Sat, 31 Aug 2002 04:34:09 GMT
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?
- Next message: Oskar: "execute a stored job through MS ACCESS 2000"
- Previous message: Bill: "SQL Server 2000 Login Security / Permissions"
- Next in thread: John Bell: "Re: logged in user can't see tables"
- Reply: John Bell: "Re: logged in user can't see tables"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
