Re: db_denydatawriter
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 18 Oct 2007 21:41:53 +0000 (UTC)
Ant (Ant@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Does DenyWriter only deny using the actual UPDATE, DELETE, INSERT
statements in queries, but not deny the user to graphically change data
in EM?
Nothing can prevent a user from changing a text in a cell, but EM is
fairly quite to write that to the database. For which it uses UPDATE
of course. So if she actually available to save data, something is
wrong.
Why don't you use sp_who2 from Query Analyzer to see as whom she
connects from Enterprise Manager?
Is it possible she has some admin rights which override DenyWriter
(though I doubt this).
She could be sysadmin or db_owner.
But first verify that she logs in to SQL Server with the user you think
she is using.
Next run all tests in Query Analyzer.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: db_denydatawriter
- From: Uri Dimant
- Re: db_denydatawriter
- Prev by Date: Re: Database Diagram leads to ownership issue.
- Next by Date: Re: db_denydatawriter
- Previous by thread: Re: db_denydatawriter
- Next by thread: Re: db_denydatawriter
- Index(es):
Relevant Pages
|
|
