we have more than 50 websites which are ruuning in a single database. Now, I have to implement Single Sign In functionlaity in all websites. So, I have decided to store Session in SQL server. I have run aspnet_regsql.exe with approprite options.
But this tool has created all Stoted Procedures in "dbo" Schema. Is there any way to install script in different Schema?
I can't use dbo because this is highly secured database & we can not allow user with dbo permission. I have created different Schema for tables,views & Stored Procedures & application user has only execute permmission on stored procedures.
Is it possible to save Session State in my database without giving "dbo" permission & related tables/Views/Stored procedures should be in a Schema (e.g.: TestSchema) other than dbo.
Can I configure Session State by creating a seperate user (say sessionUser) & a Seperate Schema (e.g.: SessionSchema) by providing the the full permission of this perticular Schema
You are right. Mainly I am a DB guy (but have knowledge of .NET also).
I was bit confuesed in Session & Authentication(forms). After a lot R&D & testing on various domains, I have found a way. Pls let me know, Is it correct?
1. I have set default common domain for httpCookie in web.config in all applications. Now all cookies will use same domain.
2. I have changed the Machine Key settings & these are same accross all applications.
3. domain atribute in forms authentication node in web.config is same accross all applications.
& this tecgnique is working fine without implementing sql server Session State.
But I still want to know, Can we install ASPState DB in any other Schema?
anujrathi
Member
193 Points
113 Posts
How to Install ASPState databse in different schema (other than dbo)
Jan 01, 2013 09:11 AM|LINK
Hi,
we have more than 50 websites which are ruuning in a single database. Now, I have to implement Single Sign In functionlaity in all websites. So, I have decided to store Session in SQL server. I have run aspnet_regsql.exe with approprite options.
But this tool has created all Stoted Procedures in "dbo" Schema. Is there any way to install script in different Schema?
I can't use dbo because this is highly secured database & we can not allow user with dbo permission. I have created different Schema for tables,views & Stored Procedures & application user has only execute permmission on stored procedures.
Is it possible to save Session State in my database without giving "dbo" permission & related tables/Views/Stored procedures should be in a Schema (e.g.: TestSchema) other than dbo.
Can I configure Session State by creating a seperate user (say sessionUser) & a Seperate Schema (e.g.: SessionSchema) by providing the the full permission of this perticular Schema
BrockAllen
All-Star
27524 Points
4902 Posts
MVP
Re: How to Install ASPState databse in different schema (other than dbo)
Jan 01, 2013 02:38 PM|LINK
I'm confused why single sign on has anything to do with session state.
DevelopMentor | http://www.develop.com
thinktecture | http://www.thinktecture.com/
anujrathi
Member
193 Points
113 Posts
Re: How to Install ASPState databse in different schema (other than dbo)
Jan 01, 2013 04:41 PM|LINK
You are right. Mainly I am a DB guy (but have knowledge of .NET also).
I was bit confuesed in Session & Authentication(forms). After a lot R&D & testing on various domains, I have found a way. Pls let me know, Is it correct?
1. I have set default common domain for httpCookie in web.config in all applications. Now all cookies will use same domain.
2. I have changed the Machine Key settings & these are same accross all applications.
3. domain atribute in forms authentication node in web.config is same accross all applications.
& this tecgnique is working fine without implementing sql server Session State.
But I still want to know, Can we install ASPState DB in any other Schema?