Keeping User From Deleting Table Records
- From: meangene <meangene@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 11 Sep 2009 08:28:01 -0700
Using MSSQL Server 2000, SP4. My supv uses Access 2003 to run queries off
tables in SQL and connects via ODBC using "sa". If he only needed access to a
few specific tables then I would create views for him; however, he says he
needs access to virtually all tables. Recently he inadventantly deleted many
records out of a table via Access. What security can I set up in SQL 2000
that will allow him to run queries via Access but keep him from deleting
records. I have tested with a test Windows account (network OS is Win2003
Server, R2) with odbc set to windows logon and in SQL added the user to
Security/Logins with no server role and added them as a User in the db with
db_denydatawriter selected and even went so far as to click on Permission and
put the big red X in delete column. However, when I login to domain with test
user account and use Access to run a query, I can still delete records.
.
- Follow-Ups:
- RE: Keeping User From Deleting Table Records
- From: Linchi Shea
- RE: Keeping User From Deleting Table Records
- Prev by Date: Re: very odd user permissions problem from a restore
- Next by Date: RE: Keeping User From Deleting Table Records
- Previous by thread: very odd user permissions problem from a restore
- Next by thread: RE: Keeping User From Deleting Table Records
- Index(es):
Relevant Pages
|
