No there is now row level security based on SQL Server 2000.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi Paul,

You can use a trigger:

CREATE TRIGGER DontTouchThisRow
ON MyTable AFTER UPDATE, DELETE
AS
IF EXISTS (SELECT *
          FROM   deleted
          WHERE  KeyCol = 1)    -- Column to be protected
BEGIN
 RAISERROR ('Row 1 may not be changed or removed', 16, 1)
 ROLLBACK TRANSACTION
END
go

Best, Hugo