I want to create registration form which will create user in SQL Server for sharepoint 2007. I have another database also in Oracle which is having table with user detail. How can we make username in SQL Server which will check in SQL Server and Oracle both which will check that it is already exits or not. Now when user added in sharepoint 2007 I need to add that username in sharepoint group with some role defination for document libarary. User can be in SQL Server (i.e. aspnetdb) or in Oracle. How can I do that using both database at same time. Next thing also I wanted to know How can I add user in some group for only for specified days for example 10 days only then it would be removed automatically from that group.

Hi Milind, This should give you a better idea of doing dual authentication and anonymous access. Hope this helps! http://www.andrewconnell.com/blog/archive/2006/10/21/HowToConfigPublishingSiteWithDualAuthProvidersAndAnonAccess.aspx Thanks VV

First of all thank you for reply. But it is showing only SQL Server, But how can i add Oracle as a provider. Kindly help me.

Hi Milind, Did you look at this article? http://download.oracle.com/docs/cd/E12530_01/oam.1014/e10356/shrpprtl.htm Thanks VV

I got solution for Oracle and SQL Server Multi authentication and use of custom provider which we can use. I will try it and give you people my experience on it.