DECLARE @separator char(1),
     @separator_position int, -- This is used to locate each separator character
    @array_value nvarchar(1000) -- this holds each array value as it is returned

/*this SP is called multiple times from same page, delete user perms when it called first time,
other wise previous call info will be deleted in subsequent calls*/
IF @array = 'b_all_rights'
BEGIN