Re: link table

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

From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 02/07/04 

Date: Fri, 6 Feb 2004 23:37:30 -0500

If SQL Server is set for SELECT permission only on the table then there is
NO WAY that Access can make it writable.

Therefore, the user who can make the table writable has OTHER PERMISSIONS in
SQL Server that allow this.
Perhaps the SQL Server uses Windows accounts too.
And your user who can edit data has Guest account privileges with Insert,
Update, Delete on that table. 

-- 
Joe Fallon
Access MVP
"LL" <lionelluo@hotmail.com> wrote in message
news:eOGeZrN7DHA.1460@tk2msftngp13.phx.gbl...
> 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: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • System.Security.SecurityException with .NET 2005 Only
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • After 2003 to 2005 Upgrade Wizard, Getting System.Security.SecurityException
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Error !!! SQL XML Bulkload Please help
    ... Irwin Dolobowsky ... > The schedule job gets run by SQL server Agent and the SQL server agent is ... > which has also got the administrator permission. ... Is the scheduled job running as a different user? ...
    (microsoft.public.sqlserver.xml)