>I want security on records.
>
>What is the best way to handle this.
>

There is nothing in SQL Server Declaritive (sp?)Data Integrity (DDI) to enforce rules at the row level. You will have to implement them yourself. If you want to implement the rules in SQL Server, you'll have to either use triggers or stored procedures.

-Mike