Configuring and securing sql server 2005 Express

I'm working on a project where SQL Server 2005 Express will be
installed on a Windows server 2003 server. Two client applications will
access the database remotly. One will be for administrative task and
the other one just as a reporter kind off application.

I need to create two users who will have access to this database, one
with full privilege (admin) and the other one (report) just use some
stored procedure.

All my tables and stored procedure use the same schema (dbo)
Oh and I'm using sql conection.

Can someone explain me the steps i need to follow in order to create
those two users, what are the database membership roles i need to set,
the securables, etc.
I tried various things but none seems to work correctly.

thanks in advance.
mateo

.

Relevant Pages