I am just starting with SQL server.

I want security on records.

Example: User Jan can only create, delete,read,write to records
where field perm 'has' the value "XX"

What is the best way to handle this.

Kind regards,

Jan Dorresteijn.