/*
* Get the security modules and minimum access level for the provided user and orders
*/
create procedure [dbo].[MssWebGetPermissionsForUserAndOrdersBranches]
    @inOrderIds IntList readonly,
    @inSysUserId int
as
begin
set nocount on

    declare @branchPriKeys IntList

    insert into @branchPriKeys( Item )
    select Item = Orders.BranchPriKey
    from @inOrderIds orderIds
    inner join Orders on Orders.PriKey = orderIds.Item

    select
        SecurityModuleName = userPermissions.SecurityModuleName,
        MinAccessLevel = userPermissions.MinAccessLevel
    from udfGetPermissionsForUserAndBranches(@branchPriKeys,@inSysUserId) as userPermissions
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetPermissionsForUserAndOrdersBranches] TO [MssExec]
GO