[dbo].[swcatlist]

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

Name
hwuuid
scname

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

SQL Script

CREATE VIEW    [dbo].[swcatlist]
AS
SELECT ai_swdef_hwdef_rel.hwuuid, ai_swcat_prop.scname
FROM  ai_swcat_swdef_rel, ai_swdef_hwdef_rel, ai_swcat_prop
WHERE  ai_swcat_swdef_rel.swuuid = ai_swdef_hwdef_rel.swuuid AND ai_swcat_swdef_rel.scuuid = ai_swcat_prop.scuuid
GO
GRANT SELECT ON  [dbo].[swcatlist] TO [aiadmin]
GRANT INSERT ON  [dbo].[swcatlist] TO [aiadmin]
GRANT DELETE ON  [dbo].[swcatlist] TO [aiadmin]
GRANT UPDATE ON  [dbo].[swcatlist] TO [aiadmin]
GRANT SELECT ON  [dbo].[swcatlist] TO [aipublic]
GO