Trusted Connection without an error

From: Steve Townson (steve_townson@descorind.com)
Date: 10/30/02 

From: "Steve Townson" <steve_townson@descorind.com>
Date: Wed, 30 Oct 2002 06:50:09 -0800

I have my SQL Server 2K set up for Mixed Authentication,
and I set up my NT user in SQL Server, and gave it, AND
the SQL Server user the appropriate permissions, and when
I go to log on to the server, via Access and ODBC, NOT
using a Trusted Connection, everything works great and I
can see the tables I have permission to see,

BUT, when I choose the Trusted Connection box, I have
permission to see EVERY table.

Now, how can this be if I've set up the permission for the
SQL User and the NT User with the exact same permissions?
Is it getting permissions from somewhere else or another
account?

There is NO OTHER account that is set up within SQL Server
under the database, so where could it be coming from?

I AM an administrator on this network, but when I removed
my user name from the Administrators group, it still did
the same thing, so Trusted Connections isn't something I'm
liking right now.

HELP!!

Thanks,
Steve Townson
Descor Industries

Relevant Pages

  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)
  • Re: Deny access to all users (including Administrator and DomainAd
    ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Windows Authentication - Same User Multiple Groups
    ... functionality using our WinForm app and read-only functionality using ... SQL Server permissions are not application-aware. ... App1 contains CRUD functionality using stored procs (EXEC perms on ...
    (microsoft.public.sqlserver.security)
  • Re: bitewise and
    ... with applciation functions to which they do not have permissions. ... application that used the SQL Server groups for granting permissions adding ... permissions and the SQL Server groups. ... If you are using a database system that actually creates an SQL Server ...
    (microsoft.public.sqlserver.programming)