Try our conversational search powered by Generative AI!

Database permissions required for application pool user

Vote:
 
What are the minimum required database permissions for the application pool user of an Episerver website? I created the initial database using the core sql script, but I don't want to make the application pool user db_owner on the database (we are using integrated security).
#147792
Apr 25, 2016 18:16
kowal - Jun 28, 2022 7:41
Did you got any more answers regarding this? I think its really important.
Vote:
 

Don't think I've seen such a guide really. I would personally try giving read access to all tables and then execute access to all sps. That should take care of most use cases. I know there was a table used for load balancing before that needed write access. Don't know if that's still used though (or if you need it in your project). Maybe someone from epi can give some recommendation? I think the official is still dbo.

#147794
Apr 25, 2016 19:52
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.