Re: Table permissions: No matter what I set all users have full access?
- From: "Mark" <asd@xxxxxxxxx>
- Date: Tue, 28 Mar 2006 15:00:54 GMT
Update: I have created a new Windows user (against the same domain) the
logged on to another PC as that user and can still access the database with
full permissions. The new user does not have a login on the server and is
only a member of the Guests group in the domain.
I even created a login for the user and denied SELECT permissions on various
tables and that made no difference either.
Nothing I do seems to affect what users can do to the data and the process
info under current activity always shows the server admin user, not the user
who is logged into the machine thats doing the editing. This is the same for
all databases on my test server.
Whoever I log onto the client machine as I always show up on the server as
the same admin user and even denying that user (i.e. the admin user)
permissions on specific tables makes no difference.
This is driving me crazy... Any help much appreciated
Mark
"Mark" <asd@xxxxxxxxx> wrote in message
news:98aWf.23160$814.8075@xxxxxxxxxxxxxxxxxxxxxxx
Hi
Following my earlier question ((CROSS POSTED) Very strange: Connection
under process info not whats in front-end)
I have set the permissions for a particular table so that none of the
listed users can do anything (select, insert etc.) yet when I connect from
another machine via the ADP using Windows authentication (from a login
thats not even listed in the servers users I might add) I still have full
permissions on the table. I get the impression I am missing something
here...
Any pointers much appreciated
Mark
.
- Follow-Ups:
- References:
- Prev by Date: Table permissions: No matter what I set all users have full access?
- Next by Date: ADO Find fails (yet not loaded recordset)
- Previous by thread: Table permissions: No matter what I set all users have full access?
- Next by thread: Re: Table permissions: No matter what I set all users have full access?
- Index(es):
Relevant Pages
|
|
