Hi Matthians & Sabestian,
Many thanks for your response. I got your attention. Well i fixed this "All Users" locked roles with running SQL script which asscoicate the administrator role and registered users role with it's respective portal in the database into dbo.Portals table. I used this sql to resolve the issue.
Here is my sql code:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE procedure [dbo].[create_sp_updateportalsetting]
(
@portalAliasName varchar(50),
@uname varchar(100)
)
as
begin
declare @portalID int
set @portalID=(select [PortalID] from dbo.PortalAlias where [HTTPAlias] like '%'+@portalAliasName)
declare @AdministratorId int,@AdministratorRoleId int,@RegisteredRoleId int
set @AdministratorId=(select [UserID] from dbo.Users where UserName=@uname)
set @AdministratorRoleId=(select [RoleID] from dbo.Roles where PortalID=@portalID and [RoleName]='Administrators')
set @RegisteredRoleId=(select [RoleID] from dbo.Roles where PortalID=@portalID and [RoleName]='Registered Users')
update
dbo.Portals
set
[AdministratorId]=@AdministratorId,
[AdministratorRoleId]=@AdministratorRoleId,
[RegisteredRoleId]=@RegisteredRoleId
Where
[PortalID]=@portalID
end
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
to run this code : After importing the template file and when my new portal creates , then i run this procedure like this-
EXEC [dbo].[create_sp_updateportalsetting] <PortalAliasName>,<AssociatedAdminUserName>;
Thanks Again.
Vyom Dixit