Is there a way I can prevent a specific user from updating a specific row to
a Table...?

TIA

Hey Vai,

I dont think we can prevent a specific user from updating specific row..

There is an option to prevent the column like,

DENY  INSERT, UPDATE, DELETE
ON authors  column_name
TO Mary, John, Tom

Any way just check this syntax to deny teh permission:

DENY
    { ALL [ PRIVILEGES ] | permission [ ,...n ] }
    {
        [ ( column [ ,...n ] ) ] ON { table | view }
    }
TO security_account [ ,...n ]
[ CASCADE ]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_2b95.asp

Kumar

Show quoteHide quote

Vai,
I would agree with kumar that there is no direct way of denyning any user
from updating a specific row.

But if that is the requirement then you can create an update trigger on that
table and check agaisnt the user's permission to validate the update or not.

If you could be more specific about your requirement i am sure someone will
be able to suggest you a better way.

abhishek

Show quoteHide quote

convert INT
A difficult Combining Rows problem
How to use OPENXML to retrieve detail lineitems
what is general/conventional way to reduce/prevent deadlock?
Complicated OR