CREATE    VIEW dbo.pmftoorg
        AS
        SELECT    dbo.ai_usrdef_orgtree_prop.pmf,
            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].[pmftoorg] TO [aiadmin]
GRANT INSERT ON  [dbo].[pmftoorg] TO [aiadmin]
GRANT DELETE ON  [dbo].[pmftoorg] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pmftoorg] TO [aiadmin]
GRANT SELECT ON  [dbo].[pmftoorg] TO [aipublic]
GO