[dbo].[pubappservers]

(local) > mdb > Views > dbo.pubappservers

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	6:13:12 PM Tuesday, May 05, 2009
Last Modified	7:53:16 AM Monday, November 30, 2009

Columns

Name
swuuid
swname
swver
swrel
swmod
swbld
swnote
userid
orgnm
office
hwsource
region
osname
ossp
osver
ospub
oslanguage
hwuse
fssize
fsfree
instdate
lscandate
hwuuid
hwdom
hwname
hwsn
hwtype
hwmfgr
hwmodel
hwmem
hwbiosmfgr
hwbiosver
hwbiosdate
hwprocmfgr
hwprocmodel
hwproctype
hwproccount
hwprocspeed
hwcpuperf
swpub

Permissions

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE VIEW dbo.pubappservers
        AS
        SELECT    dbo.pubappcomputers.*
        FROM    dbo.pubappcomputers
        WHERE hwuse='Server'
GO
GRANT SELECT ON  [dbo].[pubappservers] TO [aiadmin]
GRANT INSERT ON  [dbo].[pubappservers] TO [aiadmin]
GRANT DELETE ON  [dbo].[pubappservers] TO [aiadmin]
GRANT UPDATE ON  [dbo].[pubappservers] TO [aiadmin]
GRANT SELECT ON  [dbo].[pubappservers] TO [aipublic]
GO

Uses

[dbo].[pubappcomputers]
dbo

Used By

[dbo].[aip_generateviews]