CREATE    VIEW dbo.storagebot50freespace
        AS
        SELECT    TOP 50
            dbo.servercomputers.*
            FROM dbo.servercomputers
        WHERE    servercomputers.fsfree > 0
        ORDER
        BY    servercomputers.fsfree
        
GO
GRANT SELECT ON  [dbo].[storagebot50freespace] TO [aiadmin]
GRANT INSERT ON  [dbo].[storagebot50freespace] TO [aiadmin]
GRANT DELETE ON  [dbo].[storagebot50freespace] TO [aiadmin]
GRANT UPDATE ON  [dbo].[storagebot50freespace] TO [aiadmin]
GRANT SELECT ON  [dbo].[storagebot50freespace] TO [aipublic]
GO