Security :: Membership Against Multiple Database?

Feb 19, 2010

I am facing a very unique situation and need help. My problem is as follows:1. I have a basic ASP.NET website (3.5 is it helps on IIS 7) where I have implemented Membership for Authentication.2. The site caters to multiple companies (Say Company A, Company B etc.).3. For each company I need to have different database (SQL 2008). This is mandatory as i can use multiple Application in there.Now as far as the flow is concern its pretty simple:1. The user comes to this site with a QueryString like cid=123 (in actual there is a HttpModule for this, cid=123 is just for this forum purpose).2. The site using the cid=123 gets to know this user is for Company A (i have a WCF service for this, how it works is not a problem.), along with that I also get the connectionstring for the database this user should use.3. For Business implementation i have handled this nicely in my DAL Layer.4. The problem comes with Membership.5. In Membership I have writtent a custom provider, that assigns the connection on teh fly.6. But this happens only once for the application. i.e. the connectio string gets cached at application level.7. The connection string does not change untill I reset my IISwhere i can have a single WebSite, catering to different companies, using seperated databases and using Membership for Authorization.

public class CustomMembershipProvider : SqlMembershipProvider
{
public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)

[code]...

View 1 Replies


Similar Messages:

Security :: How To Create Multiple Applications With The Same Database With One Membership

Mar 23, 2011

I have more of the same applications.All tables are identical.Each application has a new user.These different applications are located in different domains such as.: domena1.com, domena2.com, domena3.com.Each domain has different users.

For each domain in the web.config change the "ApplicationName", eg.:
ApplicationName = domain1, ApplicationName = DOMAIN2, ApplicationName = domain3 ...

View 2 Replies

Security :: How To Use Multiple Membership Providers

Feb 25, 2010

In my web application am using ASP.Net Membership for authentication ann role management.But now i have a situation where i need to authenticate multiple clients against different DB based upon the URL request being send. Below is my web.Config Details.

<authentication>
<forms loginUrl="Login.aspx" defaultUrl="Login.aspx" />
</authentication>
<membership defaultProvider="QuickStartMembershipSqlProvider">
<providers>
<clear/>
<add connectionStringName="MEMBERSHIP_AND_ROLES" minRequiredPasswordLength="5"
minRequiredNonalphanumericCharacters="0"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
applicationName="SecurityQuickStart"
requiresUniqueEmail="true" passwordFormat="Hashed" name="QuickStartMembershipSqlProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</membership>
<roleManager enabled="true" defaultProvider="QuickStartRoleManagerSqlProvider">
<providers>
<clear/>
<add connectionStringName="MEMBERSHIP_AND_ROLES" applicationName="SecurityQuickStart" name="QuickStartRoleManagerSqlProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</roleManager>
ConnectionString.Config:
<add name="MEMBERSHIP_AND_ROLES" connectionString="Data Source=x.x.x.x;Initial Catalog=xxx;User ID=xxx;Password=xxx" providerName="System.Data.SqlClient"/>

Am using form authentication for user authentication. In my login page am using Membership.ValidateUser(username,password),which is using default membership provider. Now my situation is i need to override the default DB and connect to multiple DB based on URL request send to my web server.

View 1 Replies

Security :: Using Multiple Membership Providers Simultaneously

Jul 1, 2010

I want to know if we can use multiple membership providers simultaneously in a single ASP.net application.

View 1 Replies

Security :: Membership And Roles SQLExpress Database For Application Database?

Jul 11, 2010

I would like to use the Role Membership and User Security database as my application database too. That is, just add the tables and relationships required by my application's data access layer to the Membership and Roles Database to save on hosting fees, (I have to pay extra for having two databases instead of one). Of course, the connection string would have to be adjusted, but I don't see a downside considering the application's database is actually an Access database. What can I say, it was a requirement at the time.

Basically, I would like to do the opposite of this:
http://forums.asp.net/p/1162485/1925262.aspx#1925262

View 6 Replies

Security :: How To Add Multiple .Net Membership Roles For A Single Page

Mar 26, 2010

I have developed an asp.net website. I Have Used Asp.Net membership provider.My Question is , I Have Three Roles , For Eg: Basic, Intermediate, Admin ...Now , i need to apply two roles for single page say basic and admin .... How can i do this ... Plz help me .... Thanx in advance ......

if (Roles.IsUserInRole("Admin") == false)
Server.Transfer("AccessDenied.aspx");

View 6 Replies

Can Run Multiple Websites Under A Single Membership Database

Jun 8, 2010

I'm trying to plan a series of websites that all share many of the resources such as css/jscript/images/content etc. For this reason I wanted to run all of the websites under the same application and IIS profile, but depending on the URL being used change the masterpage and theme/skin.

The ASP.NET membership database seems as if it was designed with this goal in mind because it allows you to setup multiple applications, however I believe the purpose for which this was built was to allow applications to be run under virtual directories/fodlers, not on seperate urls.

View 2 Replies

Security :: Multiple Logins And Login Types In Default .NET Membership Provider?

Sep 8, 2010

What do you think about an ability of having multiple logins and login types to be attached to the same user? Let me explain this by showing how database schema can be re-factored to support this model:


Remove [Password], [PasswordSalt] columns from [Users] database tableAdd [Logins] table with one-to-many relationship between [Users] and [Logins] tables.This will allow one user to have multiple credentials attached to his or her account of different types such as Username&Password, Windows Live ID, Open ID from different providers

You will be able to restrict allowed login types and OpenID providers in web.config

So.. do you think it is a good idea to add support of this model into ASP.NET 4.5/5.0 membership service?

http://aspnet.codeplex.com/workitem/7149

View 1 Replies

Security :: Multiple Role Membership / How To Populate A Dropdown List With Users

Oct 13, 2010

I need to populate a dropdown list with users who match certain role criteria. For example, if I have the following roles: Manager, Employee, Supervisor I would like to populate the list with only the Manager and Employee roles. Some individuals have multiple roles and they should be excluded if they also have the Supervisor role as illustrated below:

Name: A , Role(s): Manager, Employee, Supervisor

Name: B, Role(s): Employee

Name: C, Role(s): Manager, Employee

The final list should only contain names B & C.

I can use Roles.GetUsersInRole("Employee") but I am not sure if this is efficient or not.

View 2 Replies

Security :: How To Update Database For Membership

Feb 22, 2011

I installed sql server express 2008 R2, no problems.

I created a database and added a table, no problems.

I'm using the entity framework, I created and am using the .edmx file, no problems.

I created a form that reads from and submits to the table, no problems.

I added the membership tables to the database, now I have problems.

I can still read from and update my table fine, so clearly the connection string in my web.config still works. But I can't add a new user or do anything with the website administration tool. It can't find any providers, and under security, it tells me it can't login into the database. When I try to register a new user, I get a failed login error, again for my database user. Yet I can login fine through Server Management Studio with the same credentials.

View 2 Replies

Security :: Connect Database With Membership?

Apr 5, 2010

This code is OK: [URL]

I wonder how to incorporate the view of my table?

Example:
I have a table:
- Products
- Customers

I have multiple users, each one to see what Products and the parties if the request with your username and password.

How does this connect to the Membership table?

View 4 Replies

Security :: Use The Membership API With An Already Exisiting Database?

Mar 17, 2010

Is it possible to use the Membership API with an already exisiting database? I have a database that is built around my own fields for the User and breaks down users into half a dozen different groups that determine their access to different parts of the site and exactly what they can do and see on different pages.

View 8 Replies

Security :: Custom Membership Using A Different Database?

Mar 28, 2010

ASPNETDB Problem - Unable to connect to SQL Server database

now, after some real soul searching, i managed to get it working, however i want to do the following:

I have a table in a database I created called "Students". Now, I have a studentId and a password in that table. What I want to do is allow users to login using their accounts.

However, I am having real trouble doing this. I want to create a custom membership provider, etc.

I have been crawling through the net looking for ways to do it but some of the sites I visited had too much complicated code.

What is the best and easiest way to do this?

View 1 Replies

Security :: Merging Membership Tables With Database?

Mar 7, 2010

I am using aspnet_regsql.exe to add membership tables to my database.

when I click the exe file it just opens up an XML file in visual web developer and does not start the wizard to merge the databases.

the run command where file is located is below

C:WINDOWSMicrosoft.NETFrameworkv2.0.50727

I just get the file below opening instead

[Code]...

View 1 Replies

Security :: SQL Express Vs SQL 2008 - Membership Database

Aug 11, 2010

I am attempting to add a database to the AppData folder. It seems to only want to use SQL Express, which I have read is not a good idea for a live website for the purposes of memberships. How do I change the default Express to SQL2008.

View 6 Replies

Security :: Using Membership Provider With Database Design?

Mar 18, 2010

I've just finished my database design and now i'm going to start implementing it in SQL Server 2008. Since i'm creating an ASP.NET Web Application i would like to use Membership Provider to manage user access to the application. In other projects (more simpler) i used Membership but always with its default parameters.

In this recent application i need to use custom user data for it to work properly.

So, what i would like to know is, how can i use my 'Users' table in my DB with .NET Membership Provider?

View 4 Replies

Security :: Get All The Users In A Certain Role From The Membership Database

Jun 7, 2010

I would like to collect all the emails from all users in a certain role. How would I do this ?

View 1 Replies

Security :: Membership Providers And Database Access

May 20, 2010

I am new to using the membership provider. I have been working in a small shop that has very focused programming and we are starting to venture out as our needs have grown. My question is the following:

Once I have created the asp schema and I set up users. How do I perform database access using those user accounts? I know how to perform access using a database account (schema), but do not understand how to use a user that only exists in a user table to access data tables.

Do I use an anonymous account and control access on the front end?

How to I track audit fields?

View 9 Replies

Security :: Website Without Any Default Membership Database?

Oct 1, 2010

I am in the initial stage of implementing a new webstie, which will use only twitter and facebook to login and use. So my approach is not use any Default memberhip database, just simple store the user data in my created "membership" database. I will set cookies and use sessions to restrict and grant access to various parts of the sites. So for example, the user creates an account and I set a cookie allowing him or her to traverse the site. And on each page request from the client browser check to see if my website cookie is there in the browser and if it has expired or not.

View 1 Replies

Security :: Security For Membership Database?

Oct 1, 2010

am working on an asp.net application with membership controls and the SQL Server database. I have this put together, however it appears that adjustments need to be made to enhance security. Many websites have membership features, so I was wondering if there are some blog posts that describe the steps that need to be made to enhance security.

View 3 Replies

Security :: Custom Membership Provider Not Connecting To Database

Jul 28, 2010

I have a custom SQL membership provider (NOT using aspdb files but our own 'People' table) that was working fine under development but doesn't even connect when it is deployed on web server. DB connection string has been changed to point to db server (checked against another web site & is fine there). The membership code (in VB) is in App_code directory so am I correct in thinking I don't need a separate DLL ? No error messages nothing just reports failed to login when I type some user credentials.

Web config file as follows

[Code]....

View 2 Replies

Security :: Using LDAP And Database To Authenticate Through Membership Provider

Jul 27, 2010

I am trying to build a security webservice that gets credentials from client application login Pages/forms and returns authorization and token(to manage session) information after authenticating using Membership provider. I am having a problem in Securing my webservice and using LDAP and Database together as an identity store distinguished based on a flag provided by clint applications.

View 4 Replies

Security :: Adding Membership Tables To Existing Database?

Feb 22, 2011

I am running windows 7 and NET Framework 4.

Problem is I dont know how to locate the asp.reg.sql tool that will do this using windows 7.

how to do this?

View 1 Replies

Security :: Unable To Connect To Database While Configuring Membership?

Feb 26, 2010

I tried creating a login page as ASP.NET web application. Then as we have to configure the page to connect to the database to retrieve user details, i clicked on the ASP.NET configuration under Website control.. I was taken to the configuration page with three tabs.. Security was the tab that i was supposed to configure.. But i am not able to go through to the security tab. I get the following error message.

"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database."

View 15 Replies

Security :: Membership.DeleteUser Not Removing User From Database

Jun 29, 2010

Membership.DeleteUser not removing user from database

//Roles.RemoveUserFromRole("markwheeler1963@hotmail.com", "customer");

View 6 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved