CREATE view  pmftoorg AS SELECT ai_usrdef_orgtree_prop.pmf, 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].[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