CREATE    VIEW dbo.desktopcomputers
        AS
        SELECT    dbo.allcomputers.*
        FROM    dbo.allcomputers WHERE hwuse='Desktop'
        /*WHERE    (osname NOT LIKE '%Server%')
        AND    (osname NOT LIKE '%server%')
        AND    (osname!='AIX')
        AND    (osname!='SunOS')
        AND    (osname NOT LIKE '%Linux%')
        AND    (osname!='HP-UX')
        AND     (    hwtype IS NULL
            OR    NOT (hwtype = 'Notebook'
            OR    hwtype = 'Laptop'
            OR    hwtype = 'Portable'))*/
        
GO
GRANT SELECT ON  [dbo].[desktopcomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[desktopcomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[desktopcomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[desktopcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[desktopcomputers] TO [aipublic]
GO