best practice question regarding AspState database for sessions

B

Bryan Ax

Quick question regarding best practices for using the AspState
database for storing session variables in .NET web applications.

I know I need to configure the web.config file with a database user
account that can not only execute stored procedures in the AspState
database, but the account needs to be able to create temporary tables,
etc. as well. What do others typically do for this? Obviously, I don't
want to use my sa account for this - do people tend to create a
dbowner account and configure this? Or do you give your IUSR account
dbowner privileges on the AspState db?

I haven't seen any best practice articles on this, but would like to
know any thoughts...

Sincerely,

Bryan Ax
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best practice and considerations in choosing source for an <ObjectDataSource> 4
DAL, design question, what is best practice doing this? 1
Custom controls settings, best practice question 2
Best practice for separating our warehouse users and servers/desktops 0
Best Practice for disconnected data? 0
Standard/Best Practice 3
Looking for best practice advice on data access for SMALL web sites - not enterprise 13
Best practice for multiple "companies" in one database/site 4

Top