I have a database mostly used for Accts Payable

Main tables :

Master - check#, ckDate,Vendor,Amount, idMaster
Detial - inv#, invAmt,invDate, idMaster, idDetail

I created 2 schemas - AccPay and DataEntry

The AccPay is for mngr and will have more permisions than DataEntry and should have dataEntry permisions.

Im very new to SQL server and using 2005.

How I want to set update and insert on both tables for DataEntry and Delete permisions for AccPay on both tables but also allow AccPay to update and insert

I have confused myself already!!!

How would i setup the schemas , i know it sounds confusing but basicly AccPay will supervise DataEntry, so i wish accpay to have dataentry permissions, and then extend them....