sql server connections/user identities

[Rod Snyder]

We have a team development environment and we just moved to vs.net 2003
Enterprise so we are now able to create stored procs right out of visual
studio. In the past we had to use enterprise manager. Our normal procedure
for db access was to set up a sql user based on the application and use that
to connect to the application to only execute stored procedures. When we
created the stored procedures in enterprise manager they defaulted to dbo.
as the owner/creator.

Now I'm in a quandry about how to have the stored procedures created in
Visual Studio. We don't want to use the application connection since we only
want that one to have execute permissions. If we use Windows authentication,
other developers don't appear to have access to the stored procedure.

Any suggestions or ways this is handled in other shops.

Rod