var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Schemas Roles
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....