Views [dbo].[Coordinators]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created8:59:40 AM Friday, December 7, 2018
Last Modified7:37:02 PM Thursday, August 29, 2024
Columns
Name
SysUserID
FullName
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
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
Uses