October 16, 2007 at 7:48 am
Hello everybody,
I’ve got very peculiar case right here.
Two machines:
- client: Windows XP SP2, Office 2003, MDAC 2.81, all latest patches, ODBC connection setup with the SQL server
- server: Windows 2000 Server SP4, SQL 2000 SP4, all latest patches
Both on the same network, same domain.
I’m using Excel query to get some data from the database on the server. User successfully authenticates (using Windows Authentication, server running in mixed mode) and accesses data in the table. If I want, however, restrict user access for that particular table, it just doesn't work. I have become a bit frustrated eventually, denied access to all operations on the table for every user that is displayed on the permission list (red X-es everywhere in Enterprise Manager) – and still, when I open Excel spreadsheet and refresh, I can read the data from the database! I thought maybe (very unlikely) there’s something cached – so restarted both client and the server – and still, data is available.
How the heck can I restrict it?
I deeply appreciate any help.
October 18, 2007 at 8:07 am
Daniel,
which check which roles your users are a member of. By default sysadmins can access any object in any database and db_owners can access any object within the database. Deny permissions are not applied for these two roles. So if you're users are meber of one of these roles denying access to one table won't work. Instead make them member of datareader and then it wil work.
Markus
[font="Verdana"]Markus Bohse[/font]
October 18, 2007 at 8:57 am
Hello Markus,
I've double checked user properties - under last tab, Database Access - nothing is selected. Effectively, user should have no rights on that SQL instace...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply