I need the BIG PICTURE.

I want to start my next Asp.net project with a SQL Server user permissions setup in development that will transfer easily to production (production will be on an ISP sharedhost box - Interland blueHalo or similar.)

Can someone point me to a FAQ or whitepaper or walkthru?