Hello Kirk,

I think previously you were using sa for login to the server.
It is a good practice to create a group and assign the rights to execute, select, insert, update, delete on all the objects to that group.

Creation of group and assigning the rights can be done through enterprise manager or by using following commands:
sp_addgroup 'myGroupName'
grant grant_option[, ...] on object_name to 'myGroupName'.

This is a one time job.

Later, through your application you can add user to a particular group.
sp_adduser 'existing sql login', 'new user name', 'myGroupName'

While exiting from the application you can again drop this user by using sp_dropuser 'new user name'


---
Raj