Forms Based Authentication - Creating Users and Roles confusion
- I'm at the point of creating the users and roles but I'm a little confused on what I need to put in the sql script parameters.
For the Create Role I am using:
The first parameter, "SharePoint_Memberhsip" is that the name of the asp.net membership database or the web application that will be using this?EXECUTE [dbo].[aspnet_Roles_CreateRole] 'SharePoint_Membership', 'Administrators'
For the Create Users script I am using:
Again, the first parameter, "SharePoint_Membership", what is that the membership db or the web app name?DECLARE <@now datetime SET @now= GETDATE() EXECUTE [dbo].[aspnet_Membership_CreateUser] 'SharePoint_Membership, 'Admin','Pa$$w0rd', '', 'email account', '', '', 1, @now, @now, 0, 0, null
Answers
Hi,
You can refer to the following article to get more information:
Bug in MOSS 2007 FBA with Insufficient Permissions in SQL Server
exec dbo.aspnet_Roles_RoleExists @ApplicationName=N'Fabrikam Portal',@RoleName=N'Authenticated Users'
The EXECUTE permission was denied on the object 'aspnet_Roles_RoleExists', database 'FabrikamPortal', schema 'dbo'.
Hope this helps.
Rock Wang
Rock Wang– MSFT- Marked As Answer byRock Wang– MSFTMSFT, ModeratorTuesday, November 10, 2009 9:45 AM
All Replies
Hi,
You can refer to the following article to get more information:
Bug in MOSS 2007 FBA with Insufficient Permissions in SQL Server
exec dbo.aspnet_Roles_RoleExists @ApplicationName=N'Fabrikam Portal',@RoleName=N'Authenticated Users'
The EXECUTE permission was denied on the object 'aspnet_Roles_RoleExists', database 'FabrikamPortal', schema 'dbo'.
Hope this helps.
Rock Wang
Rock Wang– MSFT- Marked As Answer byRock Wang– MSFTMSFT, ModeratorTuesday, November 10, 2009 9:45 AM
