link table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: LL (lionelluo_at_hotmail.com)
Date: 02/06/04 

Date: Fri, 6 Feb 2004 12:58:36 -0500

Hi, I create a user(user1) only have "read" permission in SQL server. and
through ODBC(use user1) and Access to create a link table to access the sql
server database.
At my clinet's computer, I at least saw two situations:
1. one of the computer, Access still can modify the link table but won't
save to sql
2. can modify the link table and the changes saved to sql.

I think the normal way shouldn't have permission to WRITE(UPDATE) table.
what's happening? how to track it down?

Actually I found when I create the new DB, and build the link talbe, it's
ready only.
Only after I copy it to another user's profile folder(C:\Documents and
Settings\if.CDE\desktop)
then the the link table change to can writable?

and in the sql trace tool, it shows "cde\if" as the NTUserName to execute
the query not the connected user(readonly)?

Any ideas? thanks.

Relevant Pages

  • Re: distribution clean up job fail
    ... The Administrator Account or whatever account the distribution agent is ... running under in sql 2005, or whatever account SQL Server agent is running ... permission on the share and underlying files and folders for this to work. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • RE: Run a ssis package on SQL Server 2005 Error
    ... I can run the SSIS package succesfully in BIDS under the same user as SQL ... The user is a domin user and it has full permission on the remote server, ... SQL Server 2005 and Agent are run under Domin\xxxxx, ...
    (microsoft.public.sqlserver.dts)
  • RE: Keeping User From Deleting Table Records
    ... a regular user, if you don't grant DELETE permission, he cannot delete. ... authentication and authenticate with Windows. ... Windows or is this SQL-assigned read permission done through SQL Server? ...
    (microsoft.public.sqlserver.security)
  • Re: User ASPNET in SQL Server 2000
    ... You need to disable anonymous access, enable Windows access, create group in Windows, assign permissions to that group in SQL, put ... > as the windows user then I want to logon to the SQL Server ... > now I want a permission to the SQL Server 2000 database ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How Can I Create A "Reader" Role?
    ... You need to explicitly DENY this permission to avoid ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)