CREATE    VIEW dbo.unixcomputers
        AS
        SELECT    dbo.allcomputers.*
        FROM    dbo.allcomputers
        WHERE    (osname NOT LIKE '%Windows%')
        AND    (osname NOT LIKE '%Linux%')
        
GO
GRANT SELECT ON  [dbo].[unixcomputers] TO [aiadmin]
GRANT INSERT ON  [dbo].[unixcomputers] TO [aiadmin]
GRANT DELETE ON  [dbo].[unixcomputers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[unixcomputers] TO [aiadmin]
GRANT SELECT ON  [dbo].[unixcomputers] TO [aipublic]
GO