[dbo].[Coordinators]

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	8:59:40 AM Friday, December 7, 2018
Last Modified	9:06:00 AM Friday, November 22, 2024

Name
SysUserID
FullName

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

SQL Script

/**
*
*  Returns a view of all coordinators.
*
*/

CREATE VIEW [dbo].[Coordinators]
as

select
    SysUser.SysUserID,
    FullName = dbo.FormatLastNameFirstName( SysUser.LASTNAME, SysUser.FIRSTNAME )
from SysUser
inner join SysUserLaborTypeMap on SysUserLaborTypeMap.SysUserFID = SysUser.SysUserID
inner join LaborType on( LaborType.PriKey = SysUserLaborTypeMap.LaborTypeFID and LaborType.LaborType = 'Coor' )
GO
GRANT SELECT ON  [dbo].[Coordinators] TO [MssExec]
GRANT INSERT ON  [dbo].[Coordinators] TO [MssExec]
GRANT DELETE ON  [dbo].[Coordinators] TO [MssExec]
GRANT UPDATE ON  [dbo].[Coordinators] TO [MssExec]
GO