CREATE    VIEW dbo.userhasreports
        AS
        SELECT    ai_usrdef_prop.samid as PMF,
            ai_usrdef_prop.mgr as reportsto
        FROM    ai_usrdef_prop
        
GO
GRANT SELECT ON  [dbo].[userhasreports] TO [aiadmin]
GRANT INSERT ON  [dbo].[userhasreports] TO [aiadmin]
GRANT DELETE ON  [dbo].[userhasreports] TO [aiadmin]
GRANT UPDATE ON  [dbo].[userhasreports] TO [aiadmin]
GRANT SELECT ON  [dbo].[userhasreports] TO [aipublic]
GO