CREATE  VIEW aiv_usrtoorglast AS SELECT dbo.ai_usrdef_orgtree_prop.pmf as userid,
            ud_orgdef_list.olorgname, ud_orgdef_list.olnote, ud_orgdef_list.oldiv
        FROM    dbo.ai_usrdef_orgtree_prop INNER JOIN
                dbo.ud_orgdef_list ON dbo.ai_usrdef_orgtree_prop.reportsto LIKE '%' + dbo.ud_orgdef_list.oluserlist
        
GO
GRANT SELECT ON  [dbo].[aiv_usrtoorglast] TO [aiadmin]
GRANT INSERT ON  [dbo].[aiv_usrtoorglast] TO [aiadmin]
GRANT DELETE ON  [dbo].[aiv_usrtoorglast] TO [aiadmin]
GRANT UPDATE ON  [dbo].[aiv_usrtoorglast] TO [aiadmin]
GRANT SELECT ON  [dbo].[aiv_usrtoorglast] TO [aipublic]
GO