Windows Authentication (SQL2000)


C

CJM

I have a database that a select few people will access via an access ADP
project (using Windows Authentication). Potentially anyone could open the
ADP file (though they shouldnt), but I would expect that they wouldnt be
able to edit the data unless I give them permissions in SQL.

However, it appears that anyone who opens the ADP file can edit the data via
this method.

I'm sure I must be missing something simple - why can all these people edit
the data? The only people with *any* explicit permissions are a web user,
the dbo, and a group of 'editors' - all of these are ok and are expected.

Is the problem in SQL - have I provided too much access to public users
somehow? Or does accessing the data through and ADP file change the way
permissions are assigned?

Thanks in advance

Chris
 
Ad

Advertisements

C

CJM

A simple solution as ever: I'm an idiot!

The ADP connection was using an SQL user and not Windows Authentication as I
thought...

Problem solved.


CJM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top