best practice question regarding AspState database for sessions

  • Thread starter Thread starter Bryan Ax
  • Start date Start date
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
 
Back
Top