Access through MS Access ADP for everyone?

From: Jack (jackhnospam_at_jackandjay.com)
Date: 10/12/05 

Date: Tue, 11 Oct 2005 21:19:32 -0400

Hello,

We have recently installed SQL enterprise manager. I was testing the security to the databases when I realized that if I login to XP under a standard domain user account, open MS Access, create an ADP project, then under connections, pick the sql server, I can see and pick any of the databases and then I can open and view any of the tables in any of the databases. How can this be possible? We are using NT authentication. This user has no account in SQL and is just a domain user.