i see that a user only login on a portal, but a want a user can be login on all portal, please help me :!!!!!!!! :L:L

thanks i thinks we can be use trigger in sql.
this is code trigger:

create trigger ifadduser
on dbo.tnt_users
for Insert
as
    begin transaction
    declare @userid int
    select @userid = i.userid
    from inserted i
    
    declare @portalID int
    select @portalID =  max(portalID) from dbo.tnt_PortalAlias
    declare @tong int
    select @tong = count(portalID) from dbo.tnt_PortalAlias
    declare @i int
    set @i = 0
    declare @portalID1 int
    set @portalID1 = @portalID
    while ( @i < @tong)
    begin
    set @portalID1 = @portalID
        if (not exists (select * from dbo.tnt_Userportals where UserID = @Userid and PortalID = @portalID))
        begin
                insert into dbo.tnt_Userportals(UserID, PortalID) values (@userid,@portalID)
        end
        select @portalID = Max(portalID) from dbo.tnt_PortalAlias where portalID < @portalID1
        set @i = @i + 1
    end
if (@@error <>0)    
        begin
        rollback
        end
    else
        begin
        commit transaction
        end

You can also find the trigger solution at this link http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/89/threadid/213119/scope/posts/Default.aspx

---

Robert Tango
www.workcontrol.com
Custom Modules: UserManager|UserDirectory|UserImport|PortalSSO