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