CREATE    VIEW dbo.userreportscomputers
        AS
        SELECT    dbo.ai_usrdef_orgtree_prop.reportsto,
            dbo.ai_usrdef_orgtree_prop.pmf,
            dbo.allcomputers.*
        FROM    dbo.ai_usrdef_orgtree_prop
            INNER JOIN
            dbo.allcomputers
            ON dbo.ai_usrdef_orgtree_prop.pmf = dbo.allcomputers.userid
        
GO
GRANT SELECT ON  [dbo].[userreportscomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[userreportscomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[userreportscomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[userreportscomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[userreportscomputers] TO [aipublic]
GO