My ASP.NET host only allows 3 database users per db other than the dbo.
I have one for the web app that only runs stored procs and has limited selects to tables.
One for ASP.NET membership/roles.
One for SQL cache dependency/notification.
One for logging - ELMAH / log4net.
How wou开发者_JAVA百科ld you consolidate the 4 users into 3? How do you get around limited database user accounts in ASP.NET hosts?
I'm thinking of combining the web app and logging accounts.
I would say that combining the logging and web application databases would be the most sensible choice - if you want to try and keep the separation then you could prefix the table names.
精彩评论