CREATE view  appsbycategory AS SELECT ai_swdef_prop.pubuuid, ai_swdef_prop.swuuid, ai_swdef_prop.swname, ai_swdef_prop.swver, ai_swdef_prop.swrel, ai_swdef_prop.swmod, ai_swdef_prop.swbld, ai_swdef_prop.swnote, ai_swdef_prop.laction, ai_swdef_prop.lactdate, ai_swcat_prop.scname AS scname, ai_swcat_prop.scnote AS scnote FROM  ai_swdef_prop INNER JOIN  ai_swcat_swdef_rel ON ai_swdef_prop.swuuid = ai_swcat_swdef_rel.swuuid INNER JOIN  ai_swcat_prop ON ai_swcat_swdef_rel.scuuid = ai_swcat_prop.scuuid
GO
GRANT SELECT ON  [dbo].[appsbycategory] TO [aiadmin]
GRANT SELECT ON  [dbo].[appsbycategory] TO [aipublic]
GO