Access through MS Access ADP for everyone?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 12 Oct 2005 01:51 GMT

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.

Reply to this Message

Sue Hoegemeier - 12 Oct 2005 02:18 GMT

It's allowed somehow with the security you have implemented
on the server, in the databases. It's not clear what version
or edition of SQL you are running, where the SQL Server
instance is installed - on the network and you are accessing
this over a network? It's not clear what operating system
the SQL Server is running on, is the SQL Server in a domain
or is this actually a workgroup? Did you change any of the
default security settings? Who are members of Local Admins
where SQL Server is installed? What is the status of the
guest account in Windows where SQL is installed?
What databases are you actually accessing and opening
tables? Are these system databases?

-Sue

>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.

Reply to this Message