SET QUOTED_IDENTIFIER OFF
GO

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