Views [dbo].[aiv_usrtoorglast]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:06 PM Sunday, December 05, 2010
Last Modified12:42:10 PM Sunday, December 05, 2010
Columns
Name
userid
olorgname
olnote
oldiv
Permissions
TypeActionOwning Principal
GrantSelectaiadmin
GrantSelectaipublic
SQL Script
CREATE view  aiv_usrtoorglast AS SELECT ai_usrdef_orgtree_prop.pmf as userid, ud_orgdef_list.olorgname, ud_orgdef_list.olnote, ud_orgdef_list.oldiv FROM  ai_usrdef_orgtree_prop INNER JOIN  ud_orgdef_list ON ai_usrdef_orgtree_prop.reportsto LIKE '%' + ud_orgdef_list.oluserlist
GO
GRANT SELECT ON  [dbo].[aiv_usrtoorglast] TO [aiadmin]
GRANT SELECT ON  [dbo].[aiv_usrtoorglast] TO [aipublic]
GO
Uses