Web application user - standard permissions? 1

[pwills]

I'd like to create a user "application" with which I connect to SQL Svr from all my web applications (rather than using dbo).

Given that I have a standard database-driven website where users can insert,update, delete records is there a pre-defined role in Sql Svr 2k that I can assign to "application"?

I am hoping this is a pretty common requirement and therefore Microsoft thought of a suitable role definition.

 

[MeanGreen]

As long as your application will only be in one database, you can use the APPLICATION ROLE. I think this would do what you are trying to do.

Hope this helps.